Viewing by month: February 2004
Most Famousest
I am the most famousest Dan Short in the WHOLE WORLD BWAAHAHAHAHAHAHAHAHAHA.
Theme Day: New takes on old styles
- Andrew Bird's Bowl of Fire (lead singer of SNZ)
- Cherry Poppin' Daddies (local boys who had their 15 minutes :)
- Harry Connick, Jr.
- Indigo Swing
- Katharine Whalen (nother lead of SNZ)
- Squirrel Nut Zippers (the SNZ)
- Stray Cats
- Pink Martini
Calling All MySQL Geeks
I'm going bald, and it's all MySQL's fault... (at least I hope it is).
I'm having major issues with MySQL returning dates in Binary format, versus the format that I give them. Let's take the following code for example:
DATE_FORMAT(tbl_orders.order_Date,'%Y-%m-01')
Now any sensible person would expect that to return "2003-12-01" right? Well, MySQL doesn't seem to want to be sensible, because it's returning this in my CFDUMP: binary - 50484851454854454849
If anyone has an idea of why the heck this is happening, I'd be more than happy to listen and try something else. I've tried using EXTRACT and piecing together a string, I've tried using STR_TO_DATE, I've tried yelling and screaming and calling it names, and nothing seems to be behaving correctly, and noone seems to know the answer.
Leave a comment if you have any idears :)