Found one CONVERT(date_format(repeat_end_date,'%Y%m'), CHAR) as dateGroup
It has to come out of mySQL as a string, not a date Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Tuesday, August 17, 2004 2:25 PM To: CFAussie Mailing List Subject: [cfaussie] Re: mySQL headache Yeah, I remember that happening to me when I was using 3.* of mySQL. I thought it was fixed in 4.*, but I guess I was wrong. No solution as far as I could see. Mark On Tue, 17 Aug 2004 14:14:00 +1000, Steve Onnis <[EMAIL PROTECTED]> wrote: > Can someone tell me why when I use a date function in mySQL, coldfusion looks at the > value as a binary value? Its driving me mental > > Something as simple as > > date_format(repeat_end_date,'%Y%m') as dateGroup > > returns a binary value and as such I cant use it as a date > > any ideas? > > Am running CFMX6.1 and mySQL 4.0.15 > > Regards > Steve Onnis > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
