Subject Re: [firebird-support] Extract Date
Author John Khoo
Is it possible to convert to date field into a string with 'yyyy/mm/dd' format?
E.g. select format('yyyy/mm/dd', Edit_Time) from Table
What function can I use to convert 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]