Add second in date

[#1]

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 [:)]

[#2]

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:

Date + (1/86400)

Should add one second to your date.

[#3]

Thank you and if is a date time?

[#4 · Accepted solution]

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.

[#5]

Thank you very much 🙂

I have another problem I have post a new topic you can help me too ? it's LOAD and RESIDENT 🙂