Subject Re: [firebird-support] Extract Date
Author John Khoo
I don't quite understand what u mean.  Anyway I attached a snapshot of it..

--- On Tue, 12/2/08, Thomas Steinmaurer <ts@...> wrote:

From: Thomas Steinmaurer <ts@...>
Subject: Re: [firebird-support] Extract Date
Date: Tuesday, December 2, 2008, 10:44 AM

> 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

Perhaps it is a date/time format issue in IB Manager. Is the shown time
always 00:00:00?

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene. com
My blog:
http://blog. thomas/

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