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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190923 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
