Prompt request for sampling only dates from a DB. There is a row in the TIMESTAMP format table 0000-0-0 00:00:00, so how to make it so that only the date is displayed on the screen and not the date with time ???

    3 answers 3

    SELECT DATE_FORMAT( `date_field` , '%d %M %Y' ) AS `date_format` FROM `table_name`
    • And how to make% M - output in Russian?) - junior-web-dev
    • @ junior-web-dev, make a query before this: SET lc_time_names = 'ru_RU'; - Deonis

    DATE () function:

    SELECT DATE ( some_field ) FROM some_table

    More features - beautiful and different.

      Look here , I think you will find what you were looking for.