php - mysql:show date from datetime -
I have a field inside the table inspection, it is inspection / datatyme type of field is date time, so that the data is Yy / mm / dd hh: mm: ss
. My question is, what should I do if I want to show only date from data?
There are some solutions in other solutions, including data formatting in SQL or PHP.
Another option is to return the date portion only with the date time column:
Inspection from SELECT DATE (inspection_datetime)
Comments
Post a Comment