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 3.8.0.1.

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

From: Helen Borrie <helebor@...>
Subject: Re: [firebird-support] Extract Date
To: firebird-support@yahoogroups.com
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

../heLen


















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