Subject Convert timestamp to date
Author Bob Murdoch
Using FB1.5 dialect 1, I have a number of columns defined as DATE, and
populated with 'now'.

In a query (or sp), how can I strip the time element from this data,
allowing me to process just the date portion?

I have tried cast(cast(date_col as integer) as date), but get the
'conversion error from string...' error message. Cast(date_col as
char(10)) results in '10-Sep-200', not the hoped for '09/10/2003' that
would allow a cast back to date.


Bob M..