How to compare Two Timestamps

[Devendrudu]

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.

[chulett]

Start with SecondsSinceFromTimestamp().

[BI-RMA]

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.

[Devendrudu]

Hi BI-RMA,

thanks your suggestion but i am getting negative integer values but i want correct Time format in output.

[chulett]

It sounds like you've got your timestamps backwards. Look for other functions to convert the result to a time, they are all documented so you shouldn't really need someone else to look them up for you.

[Devendrudu]

Hi,


Thanks to all for giving valuable information.

yes i got exact result what i expected by using

SecondsSinceFromTimestamp and TimeFromMidnightSeconds

once again thanks to chulett, and BI-RMA