RE: MSSQL Query based on a date

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

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 w

Re: MSSQL Query based on a date

Try this: fullDT = createDateTime(datePart('',userDate), datePart('m',userDate), datePart('d',userDate), datePart('h',userDate), datePart('n',userDate), datePart('s',userDate)) then your comparison becomes datefield > #fullDt# Alternatively there is the createODBCDateTime function. I know th

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