> 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/