can anyone suggest me how do i separate time, day, month and year using sysdate function in ORACLE?? i am working in PRO C/C++ compiler and stuck with this problem... is it using trunc function???