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

Поделиться
HTML-код
  • Опубликовано: 27 ноя 2024

Комментарии •

  • @nabanitadas2300
    @nabanitadas2300 2 месяца назад +3

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

  • @SunkuSaiVamsi
    @SunkuSaiVamsi Год назад +2

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

  • @manojkasana9813
    @manojkasana9813 4 месяца назад

    Great Explanation in the correct order!

  • @gloryofholyjesus
    @gloryofholyjesus Год назад +2

    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
      @CodeEra2020  Год назад

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

  • @YashendraDubey-k8x
    @YashendraDubey-k8x Год назад +2

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

  • @sohamdas6585
    @sohamdas6585 4 дня назад

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

  • @prajyotkhomane4861
    @prajyotkhomane4861 Месяц назад

    Very real time use video❤

  • @aryankumardubey7872
    @aryankumardubey7872 Месяц назад

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

  • @AbhishekKumar-b1j1x
    @AbhishekKumar-b1j1x 9 месяцев назад

    Thank you 🙏

  • @javajugadcode1429
    @javajugadcode1429 Год назад +1

    Thank you so much for this video

  • @PavanKumar-vt2fj
    @PavanKumar-vt2fj 6 месяцев назад +1

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

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 2 месяца назад

    Finished watching

  • @SarathKumar-n9j
    @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

  • @sidcity4282
    @sidcity4282 Год назад

    Thanks for the video

  • @jaymahajan3871
    @jaymahajan3871 Год назад +1

    Good job 👌👌👌👌

  • @rishabhsaxena8195
    @rishabhsaxena8195 Год назад +1

    Good video 👍👍

  • @PranayNaranje-iu9gg
    @PranayNaranje-iu9gg 4 месяца назад

    You are explaining in my sql

  • @sandhyalavudya9347
    @sandhyalavudya9347 4 месяца назад

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

  • @KingsLanding-o9u
    @KingsLanding-o9u 8 месяцев назад

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

  • @SaraswathyL-s9v
    @SaraswathyL-s9v 7 месяцев назад

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

  • @amevegeta
    @amevegeta 5 месяцев назад

    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
    @VikasThakur-jp1ki 9 месяцев назад

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

  • @anilkumartamatam7378
    @anilkumartamatam7378 3 месяца назад

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

  • @mihirprajapati6500
    @mihirprajapati6500 Год назад

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

  • @raviteja-zp5ks
    @raviteja-zp5ks 7 месяцев назад

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

  • @farmaankhan6669
    @farmaankhan6669 Месяц назад

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

    • @CodeEra2020
      @CodeEra2020  Месяц назад

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

  • @jeffreystine4638
    @jeffreystine4638 2 месяца назад

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

  • @azingo2313
    @azingo2313 Год назад +1

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