Re: Unique Date/Time

From: Venkatesh Krishnamoorthy <vkrishnamoorthy_at_worldnet.att.net>
Date: 1998/04/07
Message-ID: <6gcsvg$oto@bgtnsc03.worldnet.att.net>#1/1

One way is to convert everything into seconds. Select to_char(sysdate 'yyyy-mm-dd hh:mi:ss') into v_dtetime from dual.

select the hours component and convert into seconds eg (1hr = 60x60 secs)
select the minutes component and convert into seconds eg (10mts 10x60 secs)
add the hours and minutes (both in seconds ) and the total to seconds

This gives the total seconds

Hope this helps

Venkatesh K Received on Tue Apr 07 1998 - 00:00:00 CDT