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.
Sum Timestamp value
Moderators: chulett, rschirm, roy
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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
"10/21/2010 2:57:55 PM" and "10/21/2010 6:57:55 PM"?
Moderatore - Please more to PX forum
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Craig - I think I was thinking in German and wanted to write "Moderatoren" but managed to miss-spell even that simple word.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>