· 9 years ago · Dec 01, 2016, 07:48 AM
1CREATE TABLE IF NOT EXISTS __temp_orders
2 (
3 SELECT * FROM orders
4 WHERE STR_TO_DATE(orders.data,'%d.%m.%Y') < '2016-11-01 09:35:00'
5 )
6
7SELECT * FROM orders WHERE STR_TO_DATE(orders.data,'%d.%m.%Y') < '2016-11-01 09:35:00'