How to change the data type of requireDate field in query

1.	How to change the data type of requireDate field in query
Answer» SELECT orderNumber, requiredDate FROM orders WHERE requiredDate BETWEEN '2018-01-01' AND '2018-01-31'; The query SELECTS orders WHOSE required dates are in January 2018. The data type of the requireDate COLUMN is DATE, therefore, MySQL has to convert the literal strings: '2018-01-01' and '2018-01-31'into TIMESTAMP values before EVALUATING the WHERE condition. SELECT orderNumber, requiredDate FROM orders WHERE requiredDate BETWEEN CAST('2018-01-01' AS DATETIME) AND CAST('2018-01-31' AS DATETIME);

Answer»

SELECT orderNumber, requiredDate FROM orders WHERE requiredDate BETWEEN '2018-01-01' AND '2018-01-31';

The query SELECTS orders WHOSE required dates are in January 2018. The data type of the requireDate COLUMN is DATE, therefore, MySQL has to convert the literal strings: '2018-01-01' and '2018-01-31'into TIMESTAMP values before EVALUATING the WHERE condition.

SELECT orderNumber, requiredDate FROM orders WHERE requiredDate BETWEEN CAST('2018-01-01' AS DATETIME) AND CAST('2018-01-31' AS DATETIME);

Discussion

No Comment Found

Related InterviewSolutions

What are Roles in MySQL and briefly explain any three
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
What are MySQL aliases
Creating a table with query
How to change the data type of requireDate field in query
What is a routine and how is it created
What is datatype set
What is character set in MySQL. What is the default character set in MySQL
What is a storage engine.How to prevent the use of a particular storage engine?
What is PDO and the reasons to prefer it over MySQLi