oracle--Date-time format parameter details of the second

2.8 DD Specifies the day ordinal of the month (range: 1-31)

SQLSelect To_char (sysdate,'from dual; To_char (sysdate,'DDYYYY-MM-DDP ')------------------------------27 2015-12-27 pm 18:12:08   

2.9 DDD Specifies the day of the Year (range: 1-366)

Sql>Select To_char (Sysdate, "ddd yyyy-mm-dd PM Hh24:mi:ss ) from dual; To_char (Sysdate, ' dddyyyy-mm-dd  ' ) -- ----------------------------361 2015-12-18: 13: 15           

2.10 Day Specifies the name of the date in the week

select to_char (Sysdate, '  Day Yyyy-mm-dd PM hh24:mi:ss  ") from dual; To_char (Sysdate, ' dayyyyy-mm-dd  ' ) -- ---------------------------------Sunday 2015 -12-< Span style= "color: #800000; Font-weight:bold ">27 pm 18:46:23        

2.11 MON Returns the abbreviated month of a specified date

Sql>select to_char (Sysdate, '  MON yyyy-mm-dd PM hh24:mi:ss  ") from dual; To_char (Sysdate, ' monyyyy-mm-dd  ' ) -- --------------------------------December 2015 -12-< Span style= "color: #800000; Font-weight:bold ">27 pm 18:47:33        

2.12 Month returns the full name of the specified date

Sql>select to_char (Sysdate, '  MONTH yyyy-mm-dd PM hh24:mi:ss  ") from dual; To_char (Sysdate, ' monthyyyy-mm-  ' ) -- ------------------------------December 2015 -12-< Span style= "color: #800000; Font-weight:bold ">27 pm 18:48:44        

2.13 MM Returns the month of the specified date (range: 1-12)

SQL>  Select To_char (sysdate,'MMfrom dual; To_char (sysdate,'MM')---------------------     

2.14 HH hours (range: 1-12)

SQL>  Select To_char (sysdate,'HHfrom dual; To_char (sysdate,'HH')---------------------     

2.15 HH12 hours (range: 1-12)

Select To_char (sysdate,'HH12from dual; To_char (sysdate,'HH12')-----------------------     

2.16 HH24 hours (range: 0-23)

SQLSelect To_char (sysdate,'HH24from dual; To_char (sysdate,'HH24')-----------------------     

2.17 MI returns the minute of the specified time (range 0-59) (Note that Java indicates that the minute is mm, the month is mm, and Oracle indicates that the minute is MI, the month is mm)

SQLSelect To_char (sysdate,'MIfrom dual; To_char (sysdate,'MI')---------------------      

2.18 SS Returns the number of seconds in a specified time (range: 0-59)

SQLSelect To_char (sysdate,'SSfrom dual; To_char (sysdate,'SS')---------------------      

2.19 Ff[1-9] Returns the number of milliseconds, specifying a length of 1-9, the default 6 bits (The date type in Oracle does not have a millisecond, this format will error, timestamp only milliseconds)

Sql>Select To_char (Systimestamp,‘FF9‘)FromDual To_char (Systimestamp,‘FF9‘)---------------------------487000000Sql>Select To_char (Systimestamp,‘FF4‘)FromDual To_char (Systimestamp,'FF4')---------------------------4740SQL> Select To_char (systimestamp ,'FF6') from dual; To_char (Systimestamp,'FF6')---------------------------032000  

oracle--Date Time format parameter in detail two