Working with DateDiff function.

0 votes
asked by about Quest Software Toad for Data Analysts
edited by

I have a problem while working with DateDiff function. I tried DateDiff ("h",TEHOPVM1,TEHOPVM2) where variable TEHOPVM1 = "4.05.14 05:19:09" and
TEHO
PVM2 = "20.04.14 22:16:39". I always get 0 as a result. Why is this happening?

1 Answer

0 votes
No avatar answered by (77.9k points)

It seems that you are not using the function properly. You should try with the following syntax : DateDiff (HH,TEHOPVM1,TEHOPVM2). If the result is still 0, try searching the Internet for other references or examples about this function. Might be a good idea to start with a website like W3schools. You can find plenty of references about almost all programing languages there.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...