🚀 go-pugleaf

This answer already given is the best:

CAST(MyDateTimeField as Date)

However, if you subtract two timestamps you get a number. You can then 
do math on that. Example:

select

select current_timestamp-cast('1/1/0001' as timestamp) from rdb$database;

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

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;