Using DATE() with a SELECT

The ugly way to do it is using substr(playlistDate, 1, 10).

You also can use DATE_FORMAT(playlistDate,'%y-%m-%d')

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top