Now I remember this from a while back but can't remember what the solution was: after using a date function in MySQL such as DATE_FORMAT the field returns has a binary value such as "50484851454948455050" instead of the required date string of "2003-10-22". I can convert the binary by doing a chr(x) on every group of 2 characters, but surely there's a better way?
Separate your display from your data....
Don't format your data, format your display. ;o)
If you format the data, then you can only use that query where you want the data in that format. However, if you format your display, then you can re-use that query and display the date in any format you feel like.
Somehow I suspect that formatting your date for display in the query as opposed to in the actual display brings you round to the argument of just how many fractions of a millisecond are you actually saving by doing this? Probably none.
Stephen
-- ** 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]
