mysql select distinct date from timestamp 1

mysql select distinct date from timestamp

SELECT DISTINCT(DATE()) FROM ;

Here is what the above code is Doing:
1. We’re selecting the DISTINCT dates from the column in the table .
2. We’re using the DATE() function to extract the date from the datetime column.
3. We’re using the DISTINCT() function to select only the unique dates.

Similar Posts