Nope, the column type is datetime.
John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -----Original Message----- From: Paul [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 10:48 AM To: CF-Talk Subject: RE: MSSQL Query based on a date Is your column datatype a smalldatetime by chance? That only uses precision to the minute. -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 7:47 AM To: CF-Talk Subject: MSSQL Query based on a date I'm having some strange problems with a query I'm writing. I've got data that can be inserted into a table quite a few times within a minute. I'm trying to refresh a user's view automatically by passing in the last date/time that the person got data from the server. I'm doing a simple query and my where statement says something along the lines of dateField > '#userDate#' and the query seems to be only comparing down to the minute, but not as precise as second or millisecond. I was looking through the MSSQL docs and couldn't find anything on changing the precision of the dates that it would use or anything like that. Can anyone offer advice? John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54