SQL parameter DATE_FORMAT pre funkcie na prácu s časom
SQL -> Funkcie -> Funkcie pre prácu s dátumom a časom -> SQL parameter DATE_FORMAT pre funkcie na prácu s časom
Nastavenie argumentu interval
| Skupina | Formát | Definícia |
|---|---|---|
| Roky | YYYY | Four digit year (most commonly used) |
| Roky | YYY | Day of the week fully spelled out (e.g. TUESDAY) |
| Roky | YY | Day of the week fully spelled out (e.g. TUESDAY) |
| Roky | Y | Day of the week fully spelled out (e.g. TUESDAY) |
| Roky | SYYYY | Signed year. BC is negative, and AD is positive |
| Roky | IYYY | *ISO four digit year |
| Roky | IYY | *ISO three digit year |
| Roky | IY | *ISO two digit year |
| Roky | I | *ISO one digit year |
| Roky | RR | Last two digits of year relative to current date |
| Roky | YEAR | Year spelled out (e.g. TWO THOUSAND NINE) |
| Roky | CC, SCC | Storočie |
| Mesiace | MM | Number of Mesiace since the new year (e.g. 2 = February, most commonly used) |
| Mesiace | MON | Three letter abbreviation for month (e.g. AUG = AUGUST) |
| Mesiace | MONTH | Month spelled out fully (e.g. JANUARY) |
| Mesiace | RM | Roman numeral version of MM (e.g. IV = April) |
| Mesiace | Q | Current quarter, always 1-4 |
| Dni | DDD | Number of Dni since Jan 1 in the current year |
| Dni | DD | Number of Dni since the beginning of the month (most commonly used) |
| Dni | D | Number of Dni since the beginning of the week (e.g. 2 = Monday) |
| Dni | DAY | Day of the week fully spelled out (e.g. TUESDAY) |
| Dni | DY | Day of the week abbreviated to three letters (e.g. TUE) |
| Dni | J | Julian Dni since December 31, 4713, B.C. |
| Týždne | WW | The current week number in the year (e.g. 3 = third week in January) |
| Týždne | IW | *Week in year based on ISO standard |
| Týždne | W | Number of current week in the month |
| Hodiny | HH | Number of Hodiny, always 1-12(most commonly used) |
| Hodiny | HH12 | More formal version of HH |
| Hodiny | HH24 | 24 hour time, always 0-23 |
| Minúty | MI | Number of Minúty past the current hour, always 0-59 |
| Sekundy | HH | Sekundy past the current minute, always 0-59 (most commonly used) |
| Sekundy | SSSS | Number of Sekundy since midnight, always 0-86399 |
| Qualifiers | A.M. or P.M. | Displays, or converts A.M. or P.M. notations. In TO_CHAR, both A.M. and P.M. provide equivalent functions. In TO_DATE, each represents a time of day (e.g. before or after noon) |
| Qualifiers | AM or PM | Same as above, only without the periods (i.e. "AM" vs "A.M.") |
| Qualifiers | B.C. or A.D. | In TO_CHAR, both result in displaying the century qualifier. In TO_DATE, either one will result in conversion to the appropriate epoch. |
| Qualifiers | BC or AD | Same as above, only without the periods (i.e. "BC" vs "B.C.") |
| Punctionation | .,:-/ | All five of these characters are treated as punctionation and either displayed (TO_CHAR) or ignored (TO_DATE). |
*The ISO values refer to ISO 8601, which uses different (and very specific) rules for determining which year to represent based on a given date. Please see the actual standard for the official rules.
Parameter interval používajú funkcie
TO_CHAR(date)
TRUNC(date)
Chat ku článku
Martin Kasman, M Software
Smreková 3095/23
Email: martin@kasman.sk
Telefón: 0908 270 294