Oracle Date-time Functions Daquan

Oracle Date-time functions Daquan
to_date Format (time: 2007-11-02 13:45:25 for example)

Year :
yy two digits two-digit year display value:
yyy Three digits three-bit year display value: 007
yyyy four digits four-digit year display value:

Month:
mm number two-bit month display value: one
the Mon abbreviated character set represents the display value: November, if the English version shows the
the month spelled out character set represents the display value: November, if the English version, display November

Day :
DD Number the day of the month displays the value:
DDD Number the day of the year displays the value:
dy abbreviated when in days abbreviated display value: Friday, if the English version, display Fri
Day spelled out when in days full write display value: Friday, if the English version, display Friday
Ddspth spelled out, ordinal twelfth

Hour:
HH-digits 12-hour binary display value:
hh24 digits 24-hour binary display value:

Minute:
mi digits 60 binary display value:

Second:
SS-Digits 60 binary display value:

other
Q Digit Quarterly display value: 4
WW Digit The first few weeks of the year display value:
W Digit The week of the month display value: 1

the time range in the 24-hour format is: 0:00:00-23:59: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

Reprint please specify the source:

Author: metric Technology http://www.delit.cn

Oracle Date-time Functions Daquan