Subject Re: [firebird-support] Extract Date
Author Helen Borrie
At 05:27 PM 2/12/2008, you wrote:
>I have a field which contains the date and time of the entry. How do I
>extract the date portion from it? I do not want the time, just the
>date only.

cast (myTimestampColumn as date)

or (short form)

date myTimestamp

./heLen