donjules2k wrote:

> I have decided to go with usein "dd-MMM-yyyy" as that seems to always
> work perfectly.

All formats work perfectly if you use them properly.

> What is the best format for entering a time? (Both on
> it's own and as part of a date, hence Timestamp)

HH:MM:SS in both cases. When entering timestamp put a space between date
and time. AFAIK, date should always be first.

>>dates. You can choose between dd.mm.yyyy, mm/dd/yyyy, dd-mmm-yyyy (I

IIRC, you can also use yyyy-mm-dd format.

>>more formats. Or you can use a parameter
>>INSERT INTO MY_TABLE (DATEFIELD) VALUES(:MyDate);
>>and assign it using whatever date format is defined at the client
>>(using parameters the date is passed, not a string).

Which is the best way to do it.

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net