Some date functions

Some date functions - Some date functions SQL Date Format...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 3

Some date functions - Some date functions SQL Date Format...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online