Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Why we cannot use MySQL DATE data type along with time value?
The default format for MySQL DATE data type is “YYYY-MM-DD” and in this format, there is no possibility to store the time value. Hence, we can say that we cannot use DATE data type along with time value.
As we can see in the following example MySQL returns only date value even on using time along with the date.
mysql> select DATE("2017-09-25 09:34:21");
+-----------------------------------+
| DATE("2017-09-25 09:34:21") |
+-----------------------------------+
| 2017-09-25 |
+-----------------------------------+
1 row in set (0.04 sec)However, in DATETIME and TIMESTAMP date data types we can use the time to date.
Updated on: 28-Jan-2020
65 Views
Advertisements