Subject Re: [firebird-support] Valid formats for datetime
Author Helen Borrie
At 11:01 PM 4/05/2005 +1000, you wrote:

> >I can't seem to figure out what FB 1.5 will accept for automatic
> >conversion to a DATE data type (dialect 1).

I wrote:


>If you do only want a DATE type:
>
>cast ('5/1/2005' as date)

But not in dialect 1, of course!

Should be
cast ('5/1/2005 00:00:00.0000' as timestamp) to get the "timeless"
equivalent of Dialect 3 DATE. In some expressions you can go without the
cast for this one, too.

./hb