This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Some date functions SQL Date Format Masks AMAM or PM as appropriate CCcentury number (if the year is 2000, the value is 21) Dday of the week in numeric format (1-7) DAYlong name for the day (e.g., 'SUNDAY') DDday of the month (1-31) DDDday of the year DYshort name for day (e.g., 'SUN') FMused to suppress blanks and insignificant leading zeros HHhour of the day in 12-hour format HH24hour of the day in 24-hour format MIminute within the hour MMtwo-digit month format MONshort name for month (e.g., 'NOV') MONTHlong name for month (e.g., 'NOVEMBER') PMAM or PM as appropriate RRlike 'YY', but serves as an input to function TO_DATE (see next topic) RRRRlike 'YYYY', but serves as an input to function TO_DATE (see next topic) SSsecond within the minute (0 - 59) SSSSSsecond of the day (number of seconds past midnight) Wweek of the month in numeric format WWweek of the year in numeric format YEARyear spelled out as a string YYtwo-digit year YYYYfour-digit year...
View Full Document
This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.
- Summer '10