My field name
time
timestamp
SELECT * FROM order_table WHERE DATE(`time`) AS date_part = '2016-11-30';
Remove alias from WHERE condition:
SELECT * FROM order_table WHERE DATE(time) = '2016-11-30';