Difference between revisions of "Plsql date"
From John Freier
| Line 1: | Line 1: | ||
| − | Parameter Explanation | + | Parameter Explanation |
| − | YEAR Year, spelled out | + | YEAR Year, spelled out |
| − | YYYY 4-digit year | + | YYYY 4-digit year |
| − | YYY | + | YYY |
| − | YY | + | YY |
| − | Y Last 3, 2, or 1 digit(s) of year. | + | Y Last 3, 2, or 1 digit(s) of year. |
| − | IYY | + | IYY |
| − | IY | + | IY |
| − | I Last 3, 2, or 1 digit(s) of ISO year. | + | I Last 3, 2, or 1 digit(s) of ISO year. |
| − | IYYY 4-digit year based on the ISO standard | + | IYYY 4-digit year based on the ISO standard |
| − | RRRR Accepts a 2-digit year and returns a 4-digit year. | + | RRRR Accepts a 2-digit year and returns a 4-digit year. |
| − | A value between 0-49 will return a 20xx year. | + | A value between 0-49 will return a 20xx year. |
| − | A value between 50-99 will return a 19xx year. | + | A value between 50-99 will return a 19xx year. |
| − | Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). | + | Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). |
| − | MM Month (01-12; JAN = 01). | + | MM Month (01-12; JAN = 01). |
| − | MON Abbreviated name of month. | + | MON Abbreviated name of month. |
| − | MONTH Name of month, padded with blanks to length of 9 characters. | + | MONTH Name of month, padded with blanks to length of 9 characters. |
| − | RM Roman numeral month (I-XII; JAN = I). | + | RM Roman numeral month (I-XII; JAN = I). |
| − | WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. | + | WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. |
| − | W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. | + | W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. |
| − | IW Week of year (1-52 or 1-53) based on the ISO standard. | + | IW Week of year (1-52 or 1-53) based on the ISO standard. |
| − | D Day of week (1-7). | + | D Day of week (1-7). |
| − | DAY Name of day. | + | DAY Name of day. |
| − | DD Day of month (1-31). | + | DD Day of month (1-31). |
| − | DDD Day of year (1-366). | + | DDD Day of year (1-366). |
| − | DY Abbreviated name of day. | + | DY Abbreviated name of day. |
| − | J Julian day; the number of days since January 1, 4712 BC. | + | J Julian day; the number of days since January 1, 4712 BC. |
| − | HH Hour of day (1-12). | + | HH Hour of day (1-12). |
| − | HH12 Hour of day (1-12). | + | HH12 Hour of day (1-12). |
| − | HH24 Hour of day (0-23). | + | HH24 Hour of day (0-23). |
| − | MI Minute (0-59). | + | MI Minute (0-59). |
| − | SS Second (0-59). | + | SS Second (0-59). |
| − | SSSSS Seconds past midnight (0-86399). | + | SSSSS Seconds past midnight (0-86399). |
| − | FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. | + | FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. |
| − | + | AD or A.D AD indicator | |
| − | AD or A.D AD indicator | + | BC or B.C. BC indicator |
| − | BC or B.C. BC indicator | + | TZD Daylight savings information. For example, 'PST' |
| − | TZD Daylight savings information. For example, 'PST' | + | TZH Time zone hour. |
| − | TZH Time zone hour. | + | TZM Time zone minute. |
| − | TZM Time zone minute. | + | TZR Time zone region. |
| − | TZR Time zone region. | + | |
to_date('2003/07/09', 'yyyy/mm/dd') | to_date('2003/07/09', 'yyyy/mm/dd') | ||
to_date('070903', 'MMDDYY') | to_date('070903', 'MMDDYY') | ||
to_date('20020315', 'yyyymmdd') | to_date('20020315', 'yyyymmdd') | ||
Revision as of 11:45, 21 June 2013
Parameter Explanation YEAR Year, spelled out YYYY 4-digit year YYY YY Y Last 3, 2, or 1 digit(s) of year. IYY IY I Last 3, 2, or 1 digit(s) of ISO year. IYYY 4-digit year based on the ISO standard RRRR Accepts a 2-digit year and returns a 4-digit year. A value between 0-49 will return a 20xx year. A value between 50-99 will return a 19xx year. Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. RM Roman numeral month (I-XII; JAN = I). WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. IW Week of year (1-52 or 1-53) based on the ISO standard. D Day of week (1-7). DAY Name of day. DD Day of month (1-31). DDD Day of year (1-366). DY Abbreviated name of day. J Julian day; the number of days since January 1, 4712 BC. HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59). SSSSS Seconds past midnight (0-86399). FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. AD or A.D AD indicator BC or B.C. BC indicator TZD Daylight savings information. For example, 'PST' TZH Time zone hour. TZM Time zone minute. TZR Time zone region.
to_date('2003/07/09', 'yyyy/mm/dd')
to_date('070903', 'MMDDYY')
to_date('20020315', 'yyyymmdd')
