Yes, use the date function:
SELECT date(my_date)
More Related Contents:
- generate days from date range
- MySQL’s now() +1 day
- Create date from day, month, year fields in MySQL
- How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
- How to return only the Date from a SQL Server DateTime datatype
- MySQL Insert query doesn’t work with WHERE clause
- Delete from two tables in one query
- Why would an IN condition be slower than “=” in sql?
- Get day of week in SQL Server 2005/2008
- Fulltext Search with InnoDB
- Set NOW() as Default Value for datetime datatype?
- Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
- Rewriting mysql select to reduce time and writing tmp to disk
- How do I convert from BLOB to TEXT in MySQL?
- Calculate business hours between two dates
- Can you access the auto increment value in MySQL within one statement?
- Which SQL query is better, MATCH AGAINST or LIKE?
- What does DELIMITER // do in a Trigger?
- How to create a multi-tenant database with shared table structures?
- MySQL #1140 – Mixing of GROUP columns
- MySQL: GROUP_CONCAT with LEFT JOIN
- Boolean vs tinyint(1) for boolean values in MySQL
- How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
- What does collation mean?
- What’s the correct name for an “association table” (a many-to-many relationship) [closed]
- COUNT(id) vs. COUNT(*) in MySQL
- SQL SERVER DATETIME FORMAT
- sql pulling a row for next or previous row of a current row
- Row Rank in a MySQL View
- Select Rows with Maximum Column Value group by Another Column