Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want add a second in a date time like SQL function:
DateAdd(second, -1, u.dat1erdepot) And DateAdd(second, 1, u.dat1erdepot)
you have an idea because in Qlikview I see addmonth and addYear but not addsecond.
Thank you [:)]
Datetime should work the same. A date is just a whole number (today is 40303). A datetime is the same number, but includes decimal place for the time (right now is 40303.424....). Either way, it will add 1/86400 of a day, which is one second.
I believe there is no function because QlikView allows simple math on dates. Date + 1 adds one day to the date. If the day is a whole number, then adding a second means adding the proper fraction of one day. One second is 1/86400 days. Therefore:
Should add one second to your date.Date + (1/86400)
Thank you and if is a date time?
Datetime should work the same. A date is just a whole number (today is 40303). A datetime is the same number, but includes decimal place for the time (right now is 40303.424....). Either way, it will add 1/86400 of a day, which is one second.
Thank you very much 🙂
I have another problem I have post a new topic you can help me too ? it's LOAD and RESIDENT 🙂