Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I try to compare timestamps. But i need only the date (DD.MM.YYYY) and time (hour and minutes (HH:MM)). How can I get the time in a seperate value and the secounds rounded?
Try time(frac(floor(Mydate,1/1440)),'hh:mm') as MyTime
Try time(frac(floor(Mydate,1/1440)),'hh:mm') as MyTime
It works but how should be the code for the date?
date(MyDate,'DD.MM.YYYY') should be enough. If you want to get rid of the hours and minutes etc to keep only whole days use date(floor(MyDate),'DD.MM.YYYY')
Using floor() cuts off the fractions on the data level, and it can save a lot in the file size.
>>date(MyDate,'DD.MM.YYYY') should be enough. If you want to get rid of the hours and minutes etc to keep only whole days use date(floor(MyDate),'DD.MM.YYYY')
daystart(MyDate) is handy to get rid of the hours and minutes