27-Date & Time Functions in SQL | Types of SQL Functions| Examples | DATE_FORMAT(), DATE_ADD(),etc..

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
📚 SQL Practice Questions -
codeera.netlify.app/sql-pract...
🔶Create Employee Table
codeera.netlify.app/wp-conten...
🔶Insert Data into Employee Table
codeera.netlify.app/wp-conten...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlify.app/
✅ Subscribe us on TH-cam: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroupCodeEra
📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()
• 26-Numeric Functions i...
📌25-String Functions in SQL
• 25-String Functions in...
📌24-Difference Between WHERE and HAVING CLAUSE in SQL
• 24-Difference Between ...
📌23-HAVING CLAUSE in SQL
• 23-HAVING CLAUSE in SQ...
📌22 -GROUP BY Clause in SQL
• 22 -GROUP BY Clause in...
📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN
• 21-Aggregate Functions...
📌20 -TOP Clause in SQL | FETCH FIRST Clause
• 20 -TOP Clause in SQL ...
📌19- LIMIT and OFFSET in SQL
• 19- LIMIT and OFFSET i...
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
string functions in sql
string functions in sql
string functions in sql in english
string functions in mysql
mysql string functions
string functions in mysql in hindi
#sql
#sqlcourse
#sqlforbeginners
#string
#strings
#stringfunctions
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#sql
#having
#sqlhavingclause
#groupbyclause
#sqlgroupbyclause
#sqlselectcommand
#LearnCoding
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncoding
#clause
#sqlserver
#top
#sqlqueries
#dateandtimefunctionsinsql
#datefunctionsinsql
#datefunctionsinsqlserver
#GETDATE
#DATEADD
#DATEDIFF
#DATENAME
#datefunctions
#DatefunctionsinSQLserver
sql data types
GETDATE
DATEADD
DATEDIFF
DATENAME
date functions
Date functions in SQL server
SQL Server tutorial
ISDATE
DATEPART
CURRENT_TIMESTAMP
DAY
MONTH
YEAR
datename function in sql
datename sql

[@sidcity4282]

Thanks for the video

[@user-kn2bs5mu7b]

Thank you 🙏

[@DATAANALYST-el4di]

Explanation really awesome

[@SunkuSaiVamsi]

Select id,name,DATESUB( dob, INTERVAL 3 YEAR) as updated_date_of_birth from employee

[@javajugadcode1429]

Thank you so much for this video

[@CodeEra2020]

You are welcome!

[@amevegeta]

Hi Saloni i want to subtract date from 2 different columns and want the output in days but it is not working kindly suggest

[@user-tj5ry5db5y]

SELECT id , name , DATESUB(dob , INTERVAL 3 YEAR) AS updated _date _of _birth from EMPLOYEE .

[@gloryofholyjesus]

Thank you so much madam soo easy for anyone can understand hatsa of for ur explaination I feel so happy I found out good channel to learn SQL with clear explanation soo thank you

[@CodeEra2020]

Thank you for your kind feedback! I'm glad you found the explanation helpful. Happy learning! 😊

[@user-br1xw2dr6u]

Hi
Date, month ,year combination using SQL query add and subtract how write the formula

[@rishabhsaxena8195]

Good video 👍👍

[@CodeEra2020]

Thanks for the visit

[@jaymahajan3871]

Good job 👌👌👌👌

[@CodeEra2020]

Thanks

[@PavanKumar-vt2fj]

Select id, name, subdate(dob, interval 3 year) as updated_date_of_birth from employee;

[@user-of2ix3fy1l]

Identify details of all the morning flights (morning means between 6AM to 11 AM, using flights table)?
please help me

[@VikasThakur-jp1ki]

Hi Saloni, thanks for making this video. I have a doubt please help me out. I have birthdate column in 06-04-1991, 6/29/1984 (datatype TEXT). So I replace the ' / ' with ' - ' . And I want it in default Format( '1991-06-04' , '1984-06-29')??

[@mihirprajapati6500]

age function not use in mysql.pls tell another function use in mysql

[@raviteja-zp5ks]

SELECT ID,NAME,DOB,SUBDATE(DOB,INTERVAL,3 YEAR) AS UPDATED_DATE_OF_BIRTH FROM EMPLOYEE;

[@azingo2313]

Stop saying so guys....it is so irritating 🥶🤯🤬😡
Use something better...like dear learners or just say developer or say we or you😊