Subject Re: [firebird-support] Extract Date
Author Thomas Steinmaurer
> 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(mydatetime as date)

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