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.netlif...
🔶Create Employee Table
codeera.netlif...
🔶Insert Data into Employee Table
codeera.netlif...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlif...
✅ Subscribe us on TH-cam: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroup...
📌-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

[@nabanitadas2300]

Saloni can you please tell me for POSTGRESQL and SQL Server what will be the following functions ?

[@manojkasana9813]

Great Explanation in the correct order!

[@aryankumardubey7872]

11:09
select id, name, dob,, date_sub(dob, interval 3 year) as updated_date_of_birth from employee;

[@YashendraDubey-k8x]

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! 😊

[@SunkuSaiVamsi]

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

[@prajyotkhomane4861]

Very real time use video❤

[@SandipanSarkar-c8v]

Finished watching

[@AbhishekKumar-b1j1x]

Thank you 🙏

[@PavanKumar-vt2fj]

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

[@PranayNaranje-iu9gg]

You are explaining in my sql

[@javajugadcode1429]

Thank you so much for this video

[@CodeEra2020]

You are welcome!

[@jaymahajan3871]

Good job 👌👌👌👌

[@CodeEra2020]

Thanks

[@sidcity4282]

Thanks for the video

[@sandhyalavudya9347]

select id,name, date_sub(dob,interval 3 years) as update_date_of_birth from employees

[@rishabhsaxena8195]

Good video 👍👍

[@CodeEra2020]

Thanks for the visit

[@anilkumartamatam7378]

we need to more examples and more explanation your explanation way good but we need some more stuff in the subject

[@SaraswathyL-s9v]

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

[@KingsLanding-o9u]

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

[@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

[@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')??

[@jeffreystine4638]

this one was difficult for me ngl i over thought the answers to the practice questions

[@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;

[@prathameshbarge-1252]

There should not be a comma after interval

[@farmaankhan6669]

aapka page not found kyu aa rha hai jisme data store hai

[@CodeEra2020]

codeera.netlify.app/wp-content/uploads/2023/11/INSERT-Records-in-Employees-Table.pdf
Sorry for the trouble

[@azingo2313]

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