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

[@nabanitadas2300]

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

[@aryankumardubey7872]

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

[@SunkuSaiVamsi]

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

[@YashendraDubey-k8x]

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

[@manojkasana9813]

Great Explanation in the correct order!

[@PavanKumar-vt2fj]

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

[@sohamdas6585]

Select id,name, date_sub(dob,interval 3, Year) as updated_date_of_birth from employee;

[@prajyotkhomane4861]

Very real time use video❤

[@javajugadcode1429]

Thank you so much for this video

[@CodeEra2020]

You are welcome!

[@AbhishekKumar-b1j1x]

Thank you 🙏

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

[@SaraswathyL-s9v]

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

[@SarathKumar-n9j]

In My SQL how to delete duplicate rows inside the table without unique identifier...? My table name: accounts My column names: username and firstname

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

[@sidcity4282]

Thanks for the video

[@sandhyalavudya9347]

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

[@jaymahajan3871]

Good job 👌👌👌👌

[@CodeEra2020]

Thanks

[@anilkumartamatam7378]

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

[@rishabhsaxena8195]

Good video 👍👍

[@CodeEra2020]

Thanks for the visit

[@PranayNaranje-iu9gg]

You are explaining in my sql

[@SandipanSarkar-c8v]

Finished watching

[@mihirprajapati6500]

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

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

[@jeffreystine4638]

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

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

[@azingo2313]

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