TIMESTAMPDIFF returning null
I am trying to use the TIMESTAMPDIFF function to find the number of hours between two timestamps. However it is returning null.
The value of `end time` in my table is 09/06/2017 08:30 PM
The value of `start time` in my table 09/06/2017 03:00 PM
My formula is TIMESTAMPDIFF(HOUR,`end time`,`start time`)
What am I doing wrong?
Subject
Written By
Posted
TIMESTAMPDIFF returning null
September 10, 2017 01:45PM
September 10, 2017 06:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.