Comparing timestamps in a PX job

[Rajesh_kr82]

I have two timestamps and i want to compare them in a PX job. I think there is no inbuilt routine for this kind of comparison. Has any one implemented this, if yes then can i have the code and the steps to use it?

Rajesh

[ArndW]

Rajesh,

start at Page B-1 of the Parallel Job Developer's Guide and look at the various date functions. Convert your two dates into numeric values using any one of the methods and you have a method of comparing them.

[kumar_s]

And here is one

Code: Select all

SecondsSinceFromTimestamp
Returns the number of seconds between two timestamps in seconds.

[ray.wurlod]

Is it not possible to compare two timestamps directly? Since they are of the same data type, surely any comparison operator will return a true/false result?

[nvuradi]

And here is one

Code: Select all

SecondsSinceFromTimestamp
Returns the number of seconds between two timestamps in seconds.

Hi I have used this in My job but this function is returning 0 always. i used a stage variable with Integer 1 to capture the result.

can let me know how to get the proper difference between 2 timestamps?

Thanks
Naren

[dh_Madhu]

Well, Recently I prefered handling it in the sql itself to query a database with 1 million records (and growing...)

[JoshGeorge]

As noted, you can compare dates or timestamps directly.

Date1=Date2

or

Timestamp1=Timestamp2

If they are different you will get the Status:0
If they are same you will get the Status:1

I have two timestamps and i want to compare them in a PX job.