121>.取时间点的日的写法: & p0 T' [6 ^+ L$ b4 Z
select to_char(sys2003-10-17,’dd’) from dual;
4 Q/ ~9 W& h- }8 P+ h
6 @# a2 V) O5 O9 j9 X5 C7 ]% v122>.取时间点的时的写法: . G$ Z, S7 [# T; E
select to_char(sys2003-10-17,’hh24’) from dual;
& e. J2 }9 J- z7 Z 1 I* k5 A& c* N4 S# a
123>.取时间点的分的写法: - A2 ?0 n# ]7 p: P
select to_char(sys2003-10-17,’mi’) from dual;
0 p+ j2 b6 i3 |) I, n2 g s9 U/ d
2 W+ T0 u k4 b( M( }1 h% E124>.取时间点的秒的写法: " \* Y" z k: o( B K$ m# D
select to_char(sys2003-10-17,’ss’) from dual; $ H7 y# E n9 ?8 W7 Q) c/ B ~
* J' H' q8 q z; D125>.取时间点的日期的写法:
- r* b6 T U- X" hselect trunc(sys2003-10-17) from dual; |