Get data for specific date sql [ Solved ] 2022

    By: Manu
    1 year ago
    Category: MysqlViews: 38

    Get data for specific date sql, May be you want to check data for specific date according to some column in database you can try this query.

    // SELECT * FROM TABLE_NAME WHERE CAST(COLUMN_NAME AS date) = 'DATE';

Change -> TABLE_NAME, COLUMN_NAME and DATE


SELECT * FROM posts WHERE CAST(created_at AS date) = '2022-04-18';