Mysql strip time component from datetime January 1, 2023 by Tarik Yes, use the date function: SELECT date(my_date)