Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
string time compare
drop table splash; CREATE TABLE splash ( id int, time1 varchar(255), time2 varchar(255) ); INSERT INTO splash (id, time1, time2) VALUES (1, '01:00 pm', '10:00 pm'), (2, '11:00 am', '01:00 pm'), (3, '09:00 am', '11:00 am'), (4, '05:00 pm', '11:59 pm'); select time1, time2 from splash where str_to_date(time1,'%h:%i %p') > str_to_date('12:00 pm','%h:%i %p') or str_to_date(time2,'%h:%i %p') < str_to_date('10:00 am','%h:%i %p') order by 1,2;
run
|
edit
|
history
|
help
2
ritesh
farmaciacarnaru
Demo: procedure and delimiter
ITM_14210069
nw
Closest companies
Sql
123
Show tables
calculate averages for students and levels