Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to get no of days days between two columns
data is in below format in both columns
1899-12-31 00:00:00:0
thanks
still same issue
Hi,
try below
interval(floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')),'D')
or
interval(floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t'),'D')
or
floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t')-floor(timestamp#(date1,'YYYY-MM-DD hh:mm:ss.t'))
Regards,
Regards
Can you provide your sample data or app?
i
used this ceiling syntax and able to see correct data , when i cross check i see correct data. but in overall data it is not coming in sorted form.
how can i get sorted data
I didn't get what you are looking for.. I mean sorted data ?
You want to sort on what..??
yes sorted data