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
difference between two timestamps
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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.