select
year = to_char(myTime,'YYYY') ,
month = to_char(myTime,'MM') ,
day = to_char(myTime,'DD') ,
hour = to_char(myTime,'HH24') ,
minute = to_char(myTime,'MI') ,
second = to_char(myTime,'SS')
from
tname
year = to_char(myTime,'YYYY') ,
month = to_char(myTime,'MM') ,
day = to_char(myTime,'DD') ,
hour = to_char(myTime,'HH24') ,
minute = to_char(myTime,'MI') ,
second = to_char(myTime,'SS')
from
tname
呵呵,老兄的ORACLE的句子中还是夹着SQLSERVER的韵味儿^_^
下面的同理,和二楼的差不多.