Subject Re: [firebird-support] Extract Date
Author John Khoo
I try the following statement but the time is still appear when I run it.
select cast(Edit_Time as date) from ML_FG_EFFicientD
Could it due to different IB Version?  I am using  IB Manager

--- On Tue, 12/2/08, Helen Borrie <helebor@...> wrote:

From: Helen Borrie <helebor@...>
Subject: Re: [firebird-support] Extract Date
Date: Tuesday, December 2, 2008, 7:08 AM

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


[Non-text portions of this message have been removed]