Hi
I Have source contain two fields current time(timestamp) and previous time(timestamp)
my target field Differ_Time(Time)
example:
Input
previous time,current time
2005-04-25 17:25:43,2005-04-25 18:25:43
Output:
Differ_Time
1:00:00
what function i have to use in Transformer for this .
please help me.
How to compare Two Timestamps
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
How to compare Two Timestamps
Devendra,Bangalore,India
Re: How to compare Two Timestamps
Hi Devendrudu,
Use SecondsSinceFromTimestamp (Returns the number of seconds between two timestamps). You will, of course, have to reconvert the numeric value to a time-datatype.
Use SecondsSinceFromTimestamp (Returns the number of seconds between two timestamps). You will, of course, have to reconvert the numeric value to a time-datatype.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
Re: How to compare Two Timestamps
Hi BI-RMA,
thanks your suggestion but i am getting negative integer values but i want correct Time format in output.
thanks your suggestion but i am getting negative integer values but i want correct Time format in output.
Devendra,Bangalore,India
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am