how to get data using date on my time stamp in SQL

Question

My field name

time

and datatype is

timestamp

SELECT

    *

FROM

    order_table

WHERE

    DATE(`time`) AS date_part = '2016-11-30';

Answer 1

Remove alias from WHERE condition:

SELECT
    *
FROM
    order_table
WHERE
    DATE(time) = '2016-11-30';

Sign up