121>. Writing of the day of time:
Select to_char (sysdate, 'dd') from dual;
122>. Writings at the time point:
Select to_char (sysdate, 'hh24') from dual;
123>. Writing method for time point:
Select to_char (sysdate, 'mi') from dual;
124>. Writing of seconds in time:
Select to_char (sysdate, 'ss') from dual;
125>. Date of taking the time point:
Select Trunc (sysdate) from dual;
126>. Take the time of time point:
Select to_char (sysdate, 'hh24: mi: ss') from DUAL
127>. Date, time form becomes character form
Select to_char (sysdate) from DUAL
128>. Convert the string into a date or time form:
SELECT TO_DATE ('2003/08/01') from dual;
129>. Returns the weekly writing method:
Select to_char (sysdate, 'd') from dual;
130>. Returns the first few days of the year:
Select to_char (sysdate, 'ddd') from dual;
