Also....from the MySQL docs.... "Note also that some functions like MIN() and MAX() will convert a TIMESTAMP/DATE to a number. This means that a timestamp with a 2-digit year will not work properly with these functions. The fix in this case is to convert the TIMESTAMP/DATE to 4-digit year format or use something like MIN(DATE_ADD(timestamp,INTERVAL 0 DAYS))."
HTH! > -----Original Message----- > From: Niklas Richardson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 01, 2003 1:51 PM > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX & MySQL - Dates becoming binary > objects!!!!! > > > From some more research, it seems that it happens only when I > use MySQL date > functions on a date column. > > If I just query the columns directly without any functions it > returns it > correctly. > > Weird. Still - if anyone knows the fix...that'd be great. > > > -----Original Message----- > > From: Niklas Richardson [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 01, 2003 1:10 PM > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] CFMX & MySQL - Dates becoming binary > objects!!!!! > > Importance: High > > > > > > Hi everyone, > > > > Anyone run into a problem of CFMX returning dates from MySQL > > record sets as > > binary objects? > > > > If so - how do you stop it happening? > > > > Thanks > > > > Niklas > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
