MySQL #34: Date Time Data Types In One Video In SQL 

Welcome, Date-Time Data Types In SQL in Hindi. MySQL DATE data types explained in Hindi.
SQL Dates in Hindi.
The most difficult part when working with dates is to be sure that the format of the date you are trying to insert, matches the format of the date column in the database.
As long as your data contains only the date portion, your queries will work as expected. However, if a time portion is involved, it gets more complicated.
SQL Date Data Types
MySQL comes with the following data types for storing a date or a date/time value in the database:
DATE - format YYYY-MM-DD
DATETIME - format: YYYY-MM-DD HH:MI:SS
TIMESTAMP - format: YYYY-MM-DD HH:MI:SS
YEAR - format YYYY or YY
SQL Server comes with the following data types for storing a date or a date/time value in the database:
DATE - format YYYY-MM-DD
DATETIME - format: YYYY-MM-DD HH:MI:SS
SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS
TIMESTAMP - format: a unique number
Note: The date types are chosen for a column when you create a new table in your database!
➡️ Follow me on Instagram: vinodthapa55
Must Watch Videos For Web Development.
➡️ HTML in One Video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pN7BFLfSjFw.html
➡️ CSS in One video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hkQv0NIxKQY.html
➡️ JavaScript in One video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PODgPW-hbfU.html
➡️ ECMAScript 6 in One Video : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Iek4DtRobLA.html
➡️ HTML5 in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4V0-YpO-KZo.html
➡️ CSS3 in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TFrFx7H5ZI8.html
➡️ Bootstrap4 in One video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yZnNnvXO8HI.html
➡️ Jquery in One video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PNvyPEQ0y-I.html
➡️ JSON in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bMqevPKAPD4.html
➡️ ReactJS in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-43IbFDSVdB0.html
➡️ PHP in One Video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3024Kc6SDJ0.html
➡️ NodeJS in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ipnWAKoiBtY.html
➡️ MySQL in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5bFxbwjN-Gk.html
DONATION FOR SUPPORT: PhonePay = vinodbahadur@ybl GooglePay: vbthapa55@oksbi
Believe me, all this money will be used to make more quality videos and to make my channel grow. So that I can always provide you awesome free videos :)
My Siter RU-vid Channel Link: ru-vid.com/show-UCEst...
Plz Subscribe with all your friends :) Thank You.
click on the link below to watch web developer courses videos
HTML in One Video : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pN7BFLfSjFw.html
CSS in One Video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hkQv0NIxKQY.html
Javascript tutorial in one video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PODgPW-hbfU.html
PHP in One Video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3024Kc6SDJ0.html
DAtabase and PHP Together for read, create, update, delete: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-y5mBHPtEO5w.html
How to create a website like carbon health: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W21rnDn8L9U.html
How to create a website: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yfYch-HerV4.html
Tools I used to record videos
1: Dell Inspiron 15 5570 2018 15.6-inch FHD Laptop (8th Gen Core i3-8130/4GB + 16GB Optane Memory/1TB/Windows 10): amzn.to/2DErOoG
2: Wright WR 800 Condenser Microphone with Free USB Sound Card: amzn.to/2TjRUmc
3: Wright Wp 101 Pop Filter For Dynamic Condenser Microphone Voice Recording: amzn.to/2B67lro
4: AmazonBasics Ventilated Laptop Stand (Black): amzn.to/2DDs1Zd
5: Generic NB-35 Professional Recording Microphone Stand: amzn.to/2HBDbC1
6: JBL T160 in-Ear Headphones with Mic (Black): amzn.to/2HwbJp0
7: AmazonBasics Braided HDMI Cable - 6-Feet: amzn.to/2TkCTkc
Guys, Please support my channel by SUBSCRIBE to my channel and share my videos in your Social Network TimeLines.
Don't Forget to Follow me on all Social Network,
Website Link: www.thapatechnical.com
Instagram Link: vinodthapa55
Facebook Link: vinodthapa55
Twitter Link: vb55thapa
Facebook ThapaTechnical Page Link: vinodbahadur...