At 03:18 PM 05-01-02 +0800, you wrote:

>... and the varchar hire_date field reported as 'dd-mmm-yyyy' (e.g. '28-DEC-1988'), so I'm presuming that dates expressed anywhere as strings need to follow the dd-mmm-yyyy format?? i.e. in above, if I don't want to work in 'mm/dd/yyyy' for strings, the only alternative is to format as 'dd-mmm-yyyy' ? BTW, I have searched the docs for info on this, but no clues as yet.

Andrew:

Here are the valid date literal formats for InterBase 6 and Firebird (assume yy and yyyy are interchangeable in all cases except where noted)

'mm/dd/yyyy'
'dd.mm.yyyy'
'dd-mmm-yyyy'
'yyyymmdd' (yy not valid)

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________