| Subject | Re: extract "date 00:00:00" from timestamp |
|---|---|
| Author | mcbootchek |
| Post date | 2005-02-21T15:35:11Z |
> > I mean timestamp stored in the database is something like:Sorry, it does not work in the dialect 1 !!!!!!
> > 21.12.2004 08:45:56
>
> Isn't
>
> select cast(timestampfield as date) from...
>
> just what you are looking for?
> But I only tried that with a dialect 3-db, maybe dialect 1 behaves
> differently...