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
To: firebird-support@yahoogroups.com
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 3.8.0.1.

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. upscene.com/ thomas/

















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