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)