Sum Timestamp value

siva7143 · Post by **siva7143** » Wed Nov 24, 2010 3:06 am

Hi,

I need to group by based on BUSINESS_DAY_DATE,STORE_ID and TRANSACTION_ID and get the sum of an SIGN_ON_TIME which is an timestamp value.

Should i convert this Timestamp to dfloat before summing would an correct option?

Can anyone help me on this.

ArndW · Post by **ArndW** » Wed Nov 24, 2010 3:20 am

If your timestamp values are just number of seconds logged in, then you should be able to sum up the values without conversion. Have you tried it?

siva7143 · Post by **siva7143** » Wed Nov 24, 2010 4:25 am

My timestamp value is in the format of (10/21/2010 2:57:55 PM)

ArndW · Post by **ArndW** » Wed Nov 24, 2010 4:29 am

In that case, how would you define the sum of that timestamp? For example, what would you expect to be the answer when adding
"10/21/2010 2:57:55 PM" and "10/21/2010 6:57:55 PM"?

Moderatore - Please more to PX forum

chulett · Post by **chulett** » Wed Nov 24, 2010 7:12 am

Arnd, I didn't know you spoke Italian.

Siva, please edit your original post and add the particulars regarding your version of DataStage, job type, etc. If this turns out to be a Server question, no worries I'll just move it again.

ArndW · Post by **ArndW** » Wed Nov 24, 2010 7:28 am

Craig - I think I was thinking in German and wanted to write "Moderatoren" but managed to miss-spell even that simple word.