Originally posted by jmodic
select to_char(sysdate+ 2/24 + 35/(24*60), 'hh:mm:ss') from dual
Thanx jmodic for giving the respose
I am getting wrong results.If my systime is 05:04:03
after running the above qry i am getting the following reult
07:04:16
i have to get 07:39:16

[Edited by ravisanapala on 04-25-2001 at 07:40 AM]