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
BASE DE DATOS
pets
sree..
salamatova
ruthresh1
Práctica MySQL 1
test
Running interval
https://ru.stackoverflow.com/questions/663810
double insert (MySQL)