Let's continue with Temporal data, earlier we read strings and numeric data.
https://twitter.com/orc_arn/status/1530894610817499136
1. The major problem with dates is time zones, GMT , UTC. SQL server uses UTC. 
2. There are various date data types in Sql;
DATE YY-MM-DD
DATETIME YY-MM-DD HH:MI:SS
TIMESTAMP same as datetime
Enter your dates as strings such as;
DATE YY-MM-DD
DATETIME YY-MM-DD HH:MI:SS
TIMESTAMP same as datetime
Enter your dates as strings such as;
3. String to date conversion
Is easy with CAST()
Is easy with CAST()
4. Functions to generate date
STR_TO_DATE() function decides data type depending on your input
The second part of the function is datetime shortcuts, to learn more about %M type inputs please see
dev.mysql.com/doc/refman/5.6…
STR_TO_DATE() function decides data type depending on your input
The second part of the function is datetime shortcuts, to learn more about %M type inputs please see
dev.mysql.com/doc/refman/5.6…
5. Adding date
6. Selecting parts from a date is easy, and #MySql has many different functions such as DAYNAME(), DAYOFMONTH(). It is easier to use EXTRACT() rather than remembering all functions :)
That's all for today, for the next thread we will cover groupings.
Have a nice day, see you around.
Have a nice day, see you around.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
