Bradley M. Law

Sites with Date Formatting http://www.sql-server-helper.com/tips/date-formats.aspx http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx http://www.mssqltips.com/tip.asp?tip=1145 Other Date Formats SELECT MONTH(CURRENT_TIMESTAMP);- Return a Month(6) SELECT DAY(CURRENT_TIMESTAMP);-Return a Day:(22) SELECT DATE(CURRENT_TIMESTAMP); – returns a date (2004-06-22) SELECT TIME(CURRENT_TIMESTAMP); – returns the time (10:33:11.840) SELECT DAYOFWEEK(CURRENT_TIMESTAMP); – returns a numeric value (1-7) SELECT DAYOFMONTH(CURRENT_TIMESTAMP); – returns a day of month (1-31) SELECT DAYOFYEAR(CURRENT_TIMESTAMP); – returns the [...]