A complete Collection of ORACLE date-time functions

A complete Collection of ORACLE date-time functions

TO_DATE format (take time: 2007-11-02 13:45:25 as an example)

Year:

Yy two digits two-digit year display value: 07

Yyy three digits 3-digit year display value: 007

Yyyy four digits four-digit year display value: 2007

Month:

Mm number two-digit month display value: 11

The mon abbreviated character set represents the display value: November, if the English version, display nov

The month spelled out character set represents the display value: November, if the English version, display november

Day:

The day of the month in dd number displays the value: 02

The day of the year in which ddd number displays the value: 02

Dy abbreviated the day of the week abbreviated display value: Friday, if the English version, display fri

Day spelled out full write display value on the day of the week: Friday, if the English version, display friday

Ddspth spelled out, ordinal twelfth

Hour:

Hh two digits 12-hour display value: 01

Hh34 two digits 24-hour display value: 13

Minute:

Mi two digits 60 binary display value: 45

Second:

Ss two digits 60 binary display value: 25

Other

Q digit quarterly display value: 4

WW digit shows a value of 44 in what week of the year

W digit shows the value of the week of the month: 1

Under the 24-hour format, the time range is 0:00:00-23 59.

The time range in the 12-hour format is: 1:00:00-12:59:59.

Original address: http://bbs.delit.cn/thread-173-1-1.html

Please indicate the source of the reprint:

Written by: measurement Technology http://www.delit.cn