--- In firebird-support@yahoogroups.com, "Martijn Tonies" >

>
> Well, there are several ways to do this - probably the easiest
> is to use parameters for your date/time/datetime values:
>
> WHERE ... = :MyDateTimeParam
>
> This way, you don't have to bother about locales.
>
> Alternatively, use the English style:
>
> WHERE ... = 'mm/dd/yyyy'

Or use the standard SQL-92 format:

DATE: 'YYYY-MM-DD'

TIME: 'HH:MM:SS.mmmm'

TIMESTAMP: 'YYYY-MM-DD HH:MM:SS.mmmm'

Milliseconds (.mmmm) are optional.

Regards,
Fabrice

> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &

MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com