to find the time stamp difference

sreelekshmi · New User Joined: 16 Jan 2007 Posts: 9 Location: Bangalore

Hi,
I need to get the difference between two time stamps using SQL Query.Can anyone explain me how I can write that SQL query ?

this is urgent.

Thanks n regards,
Sree...

guptae · Posted: Mon Jul 23, 2007 12:43 pm

Hi Sree,

First of all please read forum rules.
We are not here to do ur homework so please do not specify urgent & all
Well Please find below query

sandeep1dimri · New User Joined: 30 Oct 2006 Posts: 76

Hi

Similary if one need to get difference between dates,hour, sec or microosec form time stamp can be achieived from Db2 standard functions.

for example to get various values from time stamp.

SELECT CURRENT TIMESTAMP,
YEAR (CURRENT TIMESTAMP),
MONTH (CURRENT TIMESTAMP),
DAY (CURRENT TIMESTAMP),
HOUR (CURRENT TIMESTAMP),
MINUTE (CURRENT TIMESTAMP),
SECOND (CURRENT TIMESTAMP),
MICROSECOND (CURRENT TIMESTAMP)
FROM SYSIBM.SYSDUMMY1;

So respective diff can be done on any of above values.

Hope it will help.

sandeep

sreelekshmi · New User Joined: 16 Jan 2007 Posts: 9 Location: Bangalore

I am really sorry,Only I meant is to get a quick help if possible.

Thanks for the reply
Sree..