Try to cast it as a DATE
SELECT CAST(orders.date_purchased AS DATE) AS DATE_PURCHASED
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Unknown column in ‘field list’ error on MySQL Update query
- Unknown column in ‘field list’ error on MySQL Update query
- SQL query to select dates between two dates
- MySQL – Operand should contain 1 column(s)
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL create table if not exists and insert record only if table was created
- How do I use properly CASE..WHEN in MySQL
- How can I do a FULL OUTER JOIN in MySQL?
- MySQL query String contains
- What’s the difference between VARCHAR and CHAR?
- Case statement in MySQL
- How to declare a variable in MySQL?
- ORA-01843 not a valid month- Comparing Dates
- MySQL Cannot Add Foreign Key Constraint
- Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
- How to split the name string in mysql?
- How do I import an SQL file using the command line in MySQL?
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- mysql Foreign key constraint is incorrectly formed error
- MySQL: Invalid use of group function
- How can I return pivot table output in MySQL?
- Compare dates in MySQL
- MySQL “WITH” clause
- MySQL Multiple Joins in one query?
- Error Code: 2013. Lost connection to MySQL server during query
- MySQL syntax for Join Update
- Get day of week in SQL Server 2005/2008
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- how to drop partition without dropping data in MySQL?
- MySQL combine two columns into one column
- DateTime2 vs DateTime in SQL Server
- Simple way to calculate median with MySQL
- Error 1046 No database Selected, how to resolve?
- MySQL Error 1264: out of range value for column
- How do I query for all dates greater than a certain date in SQL Server?
- How to insert date values into table
- Remove duplicate rows in MySQL
- How to SUM and SUBTRACT using SQL?
- Sql query to insert datetime in SQL Server
- Cast from VARCHAR to INT – MySQL
- SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
- How do you force mysql LIKE to be case sensitive?
- how to remove time from datetime
- MySQL – UPDATE multiple rows with different values in one query
- How to create a MySQL hierarchical recursive query?
- ERROR 1148: The used command is not allowed with this MySQL version
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- Convert timestamp to date in Oracle SQL
- MySQL starts with searching issue
- Is it possible to GROUP BY multiple columns using MySQL?
- MySQL error: key specification without a key length
- Best way to test if a row exists in a MySQL table
- Check if MySQL table exists without using “select from” syntax?
- Subtract one day from datetime
- MySQL equivalent of DECODE function in Oracle
- mysql update column with value from another table
- The used SELECT statements have a different number of columns
- Get current year in TSQL
- How to delete from multiple tables in MySQL?
- MySQL: Can’t create table (errno: 150)
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- How do I query for all dates greater than a certain date in SQL Server?
- Join vs. sub-query
- Alternative to except in MySQL
- Equivalent of explode() to work with strings in MySQL
- ROW_NUMBER() in MySQ
- MySQL OPTIMIZE all tables?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- MySQL – Get row number on select
- MySQL error: Unknown column in ‘where clause’
- How to truncate the text returned for a column in a MySQL query
- Using union and order by clause in mysql
- MySQL LIKE IN()?
- How to convert java.util.Date to java.sql.Date?
- How to change post published date to today date with SQL
- Conversion failed when converting date and/or time from character string while inserting datetime
- How do I escape a single quote in SQL Server?
- Insert text with single quotes in PostgreSQL
- SQL Server IF NOT EXISTS Usage?
- How to join two tables by multiple columns in SQL?
- Arithmetic overflow error converting numeric to data type numeric
- SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
- Backup a single table with its data from a database in sql server 2008
- Is there a coalesce-like function in Excel?
- PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/website/public_html/facebook/fbclogin.php on line 57 [duplicate]
- ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
- How to retrieve sticky post in raw sql?
- Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
- SQL User Query by Multiple Roles using PHP
- $wpdb get_var issue
- Inserting rows into a custom table, when plugin is activated
- Posts modified in the last 48 hours
- post id not displaying
- How to run complex query using PHP
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Insert multiple checkbox values
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta