June 24th, 2011, 02:02 PM
Cast from datetime to date does nothing
I am trying to cast datetime to date using the following
select log.lid, cast(log.ldate as date), log.clid, log.staid, log.emid
from tblclientlog_oes log
Resulting date comes back as datetime. Is firebird cast broken and cannot distinguish a difference between date and datetime? if so, what would be some other ways to do it.
June 26th, 2011, 01:50 AM
I have no problem to convert datetime to date this way.
I tried both with IBExpert and with isql.
How did you tried it?
June 27th, 2011, 09:57 AM
Firebird version 1.5.
IBexpert version 2005.06.07.
1/18/2008 7:43:07 AM
This is the resulting date after cast from datetime to date.
June 28th, 2011, 12:49 AM
My version of Firebird is 2.1.3.
Originally Posted by summ0ner
Have you try it with isql from command line?