on 07-26-2017 10:24 PM
I need to see the difference between two date fields for example:
SELECT T0."DocNum", T0."DocDate", T0."DocDueDate"
The difference between: (T0."DocDate " - T0."DocDueDate") = X days
Hi,
Try this function,
Datediff(day, T0.docdate, T0.Docduedate) = X days.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian,
The function is Datediff(day, T0.docdate, T0.Docduedate)
It will return an integer that is the difference in days between the given dates.
So you could use it like this:
SELECT T0.DocDate
, T0.DocDueDate
, Datediff(day, T0.docdate, T0.Docduedate) AS NumberOfDaysDifference
FROM ORDR T0
Regards,
Johan
Hi Christian,
Are you running on HANA ?
In that case you need to use the DAYS_BETWEEN function:
DAYS_BETWEEN (TO_DATE (T0.DocDate, 'YYYY-MM-DD'), TO_DATE(T0.DocDueDate, 'YYYY-MM-DD'))
Regards,
Johan
Run below function to get number of days in query generator
Datediff(day, T0.docdate, T0.Docduedate)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.