Calendar
"Calendar" is used to manage the date and time.
SQL definition |
TIMESTAMP |
- Format
Specifies the showing way of the date or time. Also besides choosing out of th list, the original definition based on the following format is also possible. You enclose the target characters by an apostrophe(') to display directly without changing the following characters.d The one- or two-digit day. dd The two-digit day. Single-digit day values are preceded by a 0. ddd The three-character day-of-week abbreviation. dddd The full day-of-week name. h The one- or two-digit hour in 12-hour format. hh The two-digit hour in 12-hour format. Single digit values are preceded by a 0. H The one- or two-digit hour in 24-hour format. HH The two-digit hour in 24-hour format. Single digit values are preceded by a 0. m The one- or two-digit minute. mm The two-digit minute. Single digit values are preceded by a 0. M The one- or two-digit month number. MM The two-digit month number. Single digit values are preceded by a 0. MMM The three-character month abbreviation. MMMM The full month name. s The one- or two-digit seconds. ss The two-digit seconds. Single digit values are preceded by a 0. t The one-letter A.M./P.M. abbreviation (A.M. is displayed as "A"). tt The two-letter A.M./P.M. abbreviation (A.M. is displayed as "AM"). y The one-digit year (2001 is displayed as "1"). yy The last two digits of the year (2001 is displayed as "01"). yyyy The full year (2001 is displayed as "2001").