<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Caution: ColdFusion Zero Date vs. SQL Zero Date Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:285.view Date Posted: Sep 22, 2006 at 8:21 AM ---- --------------------------------------------------------------------------------------- ---> SELECT ( 'SQL Zero Date' ) AS label, ( CAST( 0.0 AS DATETIME ) ) AS the_date, ( 0.0 ) AS the_float UNION SELECT ( 'CF Zero DateFormat( )' ) AS label, ( ) AS the_date, CAST( AS FLOAT ) AS the_float UNION SELECT ( 'CF Zero TimeStamp' ) AS label, ( ) AS the_date, CAST( AS FLOAT ) AS the_float UNION SELECT ( 'CF Zero DateFormat( full )' ) AS label, ( ) AS the_date, CAST( AS FLOAT ) AS the_float