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. 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