Subject | Re: [firebird-support] Valid formats for datetime |
---|---|
Author | Helen Borrie |
Post date | 2005-05-04T13:08:10Z |
At 11:01 PM 4/05/2005 +1000, you wrote:
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
> >I can't seem to figure out what FB 1.5 will accept for automaticI wrote:
> >conversion to a DATE data type (dialect 1).
>If you do only want a DATE type:But not in dialect 1, of course!
>
>cast ('5/1/2005' as date)
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