tag:blogger.com,1999:blog-912288584218945575.post5936226720130274499..comments2023-09-08T09:17:06.161-05:00Comments on ColdFusion Hell: Hacking SQL to Save CFGRID: Date FormatUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-912288584218945575.post-71692772416585218452009-01-29T15:23:00.000-06:002009-01-29T15:23:00.000-06:00In MS SQL I did this:CONVERT(VARCHAR(12), DateAdde...In MS SQL I did this:<BR/><BR/>CONVERT(VARCHAR(12), DateAdded, 101) AS DateAdded<BR/><BR/>and got the lovely:<BR/><BR/>01/27/2009 format<BR/><BR/>Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-912288584218945575.post-7713394134894172692008-12-15T16:47:00.000-06:002008-12-15T16:47:00.000-06:00You sir are my hero! If you are ever in Seattle, ...You sir are my hero! If you are ever in Seattle, I'm buying you a beer. Been looking to solve this one for awhile now. Thank you!!!mikeweezerhttps://www.blogger.com/profile/09727143766531916688noreply@blogger.com