difference between two timestamps

dodda · Post by **dodda** » Mon Jan 04, 2010 6:58 pm

hello

i want to find out the difference between two time stamps

a:2010-01-04 14:10:13
b:2010-01-04 16:22:44

how can i obtain the difference between these 2 time stamps (b-a) in datastage.what would be the resulting datatype. because i need to convert the difference between the timestamps to varchar and insert the value into database.

Thanks

Kryt0n · Post by **Kryt0n** » Mon Jan 04, 2010 7:55 pm

Have a look at the date and time help functions, all the answers you need are there...

ray.wurlod · Post by **ray.wurlod** » Mon Jan 04, 2010 8:07 pm

The difference can only be seconds. This will be a numeric data type of some kind, which can implicitly be converted to string (VarChar) provided that the string maximum size (precision) is sufficiently large.

dodda · Post by **dodda** » Mon Jan 04, 2010 8:24 pm

Hi Ray,

I tried to compute the difference by specifying the difference as Datatype Numeric.i tried with all the datatypes but i am unable to compile the job.

Thanks

ray.wurlod wrote:The difference can only be seconds. This will be a numeric data type of some kind, which can implicitly be converted to string (VarChar) provided that the string maximum size (precision) is sufficiently large.

dodda · Post by **dodda** » Mon Jan 04, 2010 8:49 pm

Hi

i used secondssincefromtimestamp function to get the difference

thanks