🚀 go-pugleaf

Robin wrote:
> Hi everyone,
> 
> I want to count distinct days in a period from a datetime field.  I am 
> surprised by how difficult I have found this.
> 
> My problem is in getting the date part of a datetime in SQL.
> 
> Is there a way to truncate a datetime to just a date?
> 
> I thought trunc or frac, but they are not available.  I can't seem to 
> cast the datetime as an integer either.
> 
> The only way I have found is to cast the datetime as varchar(11) which 
> happens to return only the date part.  Then cast THAT as an integer.
> 
> Which /appears/ to work, but makes me feel dirty ;-)
> 
> I am using Interbase6.x/FB1.5.  I am unable to make stored procedures, 
> UDF etc so I need to do it in raw SQL only.
> 
> Any ideas?
> 
> Thanks in advance.

Why not simply

CAST(MyDateTimeField as Date)

select cast(cast('19.03.2007 14:25:23:8532' as Timestamp) as Date)
from rdb$database

works for me (tested in Fb 1.5. I do not have IB 6.x, but it ought to be 
similar).

Set