datetime ldt_time
string ls_time,ls_day,ls_monthls_time = to_char(ldt_time,'yyyymmdd')
ls_day = substr(ls_time,7,2)
ls_month = substr(ls_time,5,2)
string ls_time,ls_day,ls_monthls_time = to_char(ldt_time,'yyyymmdd')
ls_day = substr(ls_time,7,2)
ls_month = substr(ls_time,5,2)
to_char(sysdate,'yyyy') year,
to_char(sysdate,'mm') month,
to_char(sysdate,'dd') day
from dual
to_char(sysdate,'dd')-----day