Swaminathan K
asked on
oracle differnce between two timestamps
Hi Team,
I have two timestamps values , how to find the difference between them
01-MAR-17 10.22.05.033085000 AM -06:00
01-MAR-17 10.22.05.033795000 AM -06:00
I have two timestamps values , how to find the difference between them
01-MAR-17 10.22.05.033085000 AM -06:00
01-MAR-17 10.22.05.033795000 AM -06:00
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
awesome
ASKER
SELECT TO_TIMESTAMP_TZ(
'01-MAR-17 10.22.05.033085000 AM -06:00',
'dd-MON-RR hh.mi.ss.ff AM TZH:TZM'
) - TO_TIMESTAMP_TZ(
' 01-MAR-17 10.22.05.033795000 AM -06:00 ',
'dd-MON-RR hh.mi.ss.ff AM TZH:TZM'
) from dual; this worked for me as mentioned by slightwv . I have just sdstuber values.
'01-MAR-17 10.22.05.033085000 AM -06:00',
'dd-MON-RR hh.mi.ss.ff AM TZH:TZM'
) - TO_TIMESTAMP_TZ(
' 01-MAR-17 10.22.05.033795000 AM -06:00 ',
'dd-MON-RR hh.mi.ss.ff AM TZH:TZM'
) from dual; this worked for me as mentioned by slightwv . I have just sdstuber values.
I don't understand what you're trying to say in that last post.
Open in new window
example usage...
Open in new window