CODEWITHSUNDEEP
mysql
sandeep autade
sandeep autade

Reputation: 401

Query to display row after 1 pm

How to fetch all rows from table where time is greater than 13:00 i.e. 1PM

SELECT * FROM `mytable` WHERE `time` >="13:00";

Upvotes: 0

Views: 58

Answers (1)

scgough
scgough

Reputation: 5252

if you have a datetime field you could do this (I'm assuming here as you haven't specified):

create table tester(`id` int(6), `name` varchar(50), `datetest` datetime);

insert into tester(`id`,`name`,`datetest`)
values(1, 'n1', '2018-12-20 09:00:00'),
(2, 'n2', '2018-12-20 10:00:00'),
(3, 'n3', '2018-12-20 13:10:00'),
(4, 'n4', '2018-12-20 14:00:00');

select * from tester 
where TIME(datetest) > '13:00'

Upvotes: 1

Related Questions