Convert date to number

November 30

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



Any hint or is not possible as Kishore said....
I would like to sum (grand total) all the days that I get from TIMESTAMPDIFF.
Invoice nr. Due date TIMESTAMPDIFF(SQL_TSI_DAY, "Invoice (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

View 5 Replies


  1. Mail Version 4.6 (1085) outgoing server
  2. how to upload excel data into forms 11g
  3. inbound delivery gr
  4. input VAT.xml
  5. 4.4.2verssion changer app
  6. Nokia 6120c midp certificate download
  7. Neha jpx pothos
  8. Profitability Segment Number service PO
  9. cisco wlc dynamic interface
  10. 30LF
Copyrights 2019 Fcffair BigData Resource, All rights reserved