Convert date to number

Advertisement
November 30

Hello.
I want to convert date field to number. I used TIMESTAMPDIFF(SQL_TSI_DAY, "Invoice date (invoice header)".Date, CURRENT_DATE ) to get number of days from invoice date to current day but this number is treated as date format and I'm not able to make calculation on that number. Any suggestions how to convert this »number« to real number that also calculation would be possible.
Thank you.
Brgds, Luka

Advertisement

Replay

Any hint or is not possible as Kishore said....
I would like to sum (grand total) all the days that I get from TIMESTAMPDIFF.
Example:
Invoice nr. Due date TIMESTAMPDIFF(SQL_TSI_DAY, "Invoice due.date (invoice header)".Date, CURRENT_DATE )
201001006978          30.11.2010     44
201001007250          8.12.2010     36
201001007392          15.12.2010     29
201001007735          23.12.2010     21
201001007815          30.12.2010     14
SUM = 144
Brgds,
L

View 5 Replies

Tags:

  1. sony kdl 42w805a netflix problem
  2. ifroget my icloud id n pasword
  3. Clash of Clans vs 11.2.3
  4. SOFFICEINTEGRATION 898 error
  5. CL_SQL_RESULT_SET=============CP
  6. 8QYE
  7. lion3ca
  8. lateru2t
  9. suddenlyki9
  10. threejde
Copyrights 2019 Fcffair BigData Resource, All rights reserved