MySQL Forums
Forum List  »  Newbie

TIMESTAMPDIFF returning null
Posted by: Matthew Fierro
Date: September 10, 2017 01:45PM

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?

Options: ReplyQuote

Written By
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.