Am I correct in thinking that these are equivalent line of code (given both
dt1 & dt2 are defined as date (dialect1) and timestamp (dialect3):

dt1 = CURRENT_TIMESTAMP;

dt2 = CAST(CAST ('NOW' AS VARCHAR(11)) as DATE);

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly