MySQL Forums
Forum List  »  PHP

Re: Given Time-In & Time-Out, Get Hours & Minutes That Fall Between 22:00 and 06:00 the FF day
Posted by: Peter Brawley
Date: January 13, 2021 11:54AM

First, you should avoid using illegal chars like '-' in database object. Until you fix that, you'll need to surround such names with backticks (see the manual on db object names).

select timediff('2021-01-12 17:00:00','2021-01-12 00:00:00');
+-------------------------------------------------------+
| timediff('2021-01-12 17:00:00','2021-01-12 00:00:00') |
+-------------------------------------------------------+
| 17:00:00                                              |
+-------------------------------------------------------+

Options: ReplyQuote


Subject
Written By
Posted
Re: Given Time-In & Time-Out, Get Hours & Minutes That Fall Between 22:00 and 06:00 the FF day
January 13, 2021 11:54AM


Sorry, only registered users may post in this forum.

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.