[thelist] SQL Dates
Martyn Haigh
McFly at Phiniusgage.com
Fri Jan 3 04:51:01 CST 2003
Just spent countless hours confused by this one, so I thought I'd share
<tip type="Formatting SQL Dates in ASP" author="Martyn Haigh">
SQL is really picky about what format you use when using dates, and this
can often cause many hours of pulling your hair out. I speak from
experience.
The normal Date() or Now() functions will often throw up unexpected
errors, so instead why not use this handy routine I copied from
4GuysFromRolla.com and put a stop to all your SQL Date headaches.
Funciton formatSQLDate(dateToFormat)
Dim aDay
Dim aMonth
Dim aYear
aDay = Day(dateToFormat)
aMonth = Monthname(Month(dateToFormat),True)
aYear = Year(dateToFormat)
formatSQLDate= aDay & "-" & aMonth & "-" & aYear
End function
This will give you a date in this format : 2-Jan-2003
Which is SQL friendly.
(don't forget to use those delimiters [#'s] when working with dates!)
</tip>
More information about the thelist
mailing list