ใช้ฟังก์ชัน CONCAT() รวมวันที่และเวลา ไวยากรณ์:
SELECT * FROM yourTableName WHERE CONCAT(yourDateColumnName, '', yourTimeColumnName) > 'yourDateTimeValue';
มาสร้างตาราง:
mysql> create table DifferentDateTime ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, ArrivalDate date, ArrivalTime time ); Query OK, 0 rows affected (1.53 sec)
แทรกข้อมูล:
mysql> insert into DifferentDateTime(ArrivalDate,ArrivalTime) values(curdate(),'10:27:30'); Query OK, 1 row affected (0.14 sec) mysql> insert into DifferentDateTime(ArrivalDate,ArrivalTime) values('2016-04-24','15:00:00'); Query OK, 1 row affected (0.18 sec) mysql> insert into DifferentDateTime(ArrivalDate,ArrivalTime) values('2015-12-25','12:30:30'); Query OK, 1 row affected (0.18 sec) mysql> insert into DifferentDateTime(ArrivalDate,ArrivalTime) values('2012-01-31','16:00:30'); Query OK, 1 row affected (0.11 sec) mysql> insert into DifferentDateTime(ArrivalDate,ArrivalTime) values('2000-07-12','09:45:31'); Query OK, 1 row affected (0.11 sec)ตัวอย่าง
แสดงข้อมูล:
mysql> select * from DifferentDateTime;
ผลลัพธ์
+----+-------------+-------------+ | Id | ArrivalDate | ArrivalTime | +----+-------------+-------------+ | 1 | 2019-02-14 | 10:27:30 | | 2 | 2016-04-24 | 15:00:00 | | 3 | 2015-12-25 | 12:30:30 | | 4 | 2012-01-31 | 16:00:30 | | 5 | 2000-07-12 | 09:45:31 | +----+-------------+-------------+ 5 rows in set (0.00 sec)
คำสั่งรวมวันที่เวลาและเปรียบเทียบ:
mysql> select * from DifferentDateTime where concat(ArrivalDate,'',ArrivalTime) > '2007-01-31 12:30:30';
ผลลัพธ์
+----+-------------+-------------+ | Id | ArrivalDate | ArrivalTime | +----+-------------+-------------+ | 1 | 2019-02-14 | 10:27:30 | | 2 | 2016-04-24 | 15:00:00 | | 3 | 2015-12-25 | 12:30:30 | | 4 | 2012-01-31 | 16:00:30 | +----+-------------+-------------+ 4 rows in set (0.00 sec)
