Oracle Tutorial - Conversion Functions TO_DATE | TO_CHAR | TO_NUMBER

Поделиться
HTML-код
  • Опубликовано: 16 окт 2024
  • Oracle Tutorials - Conversion Functions TO_DATE() | TO_CHAR() | TO_NUMBER()

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

  • @giridandi7480
    @giridandi7480 2 года назад +1

    Very nice

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

    great

  • @baskaranbaluchamy3667
    @baskaranbaluchamy3667 5 лет назад +2

    Man u r excellent . U r practical wise commend execution is really amazing. Thank u so much....

  • @aiswaryarajkumar3502
    @aiswaryarajkumar3502 3 года назад

    Simple nd clean explanations.... Good

    • @TechAcad
      @TechAcad  3 года назад +1

      Thank you so much 🙂

  • @debasreemoitra9823
    @debasreemoitra9823 4 года назад

    Hello. Nice explanation. One Query: when you are using TO_CHAR(empsalary, '$99,999,99') from Employee. How this digit is getting converted to the resultant salary number which is $50,00.Kindly help

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

    can you try with year as 1900 it will take 2000 year,can you give a conversion for the same,when date is 01/01/1900 to chat(19000101)..???

  • @shri470
    @shri470 4 года назад +1

    Tqs aa lot 💖💖💖
    My online professor🙏

    • @TechAcad
      @TechAcad  4 года назад +1

      So nice of you

  • @jotarokujo4775
    @jotarokujo4775 3 года назад

    Thank you sir, i really needed this for my online class.

    • @TechAcad
      @TechAcad  3 года назад

      Glad it was helpful!
      And thanks for your great support and sharing!

  • @kashish9285
    @kashish9285 3 года назад

    Hey, thank you for the great video. Explained each part so well. Just one question though, In the books and Oracle Documentation, 'nlsparam' is included as part of arguments list in TO_CHAR(datetime, 'fmt', 'nlsparam') - But in the examples you have shown, I only see the column/expression (sysdate) followed by the format mask. Is the nlsparam optional or is it an invisible argument? Thanks in advance :)

    • @TechAcad
      @TechAcad  3 года назад

      Yes they do

    • @moezouabi
      @moezouabi 2 года назад

      @@TechAcad bro u didnt answer what he asked lol

  • @abhijeetvidhate9574
    @abhijeetvidhate9574 4 года назад

    Can you convert the actual Colum using TO_DATE, all youtubers show just with strings. No one shows how an actual Colum value is converted.

    • @TechAcad
      @TechAcad  4 года назад

      Yes, it is possible.

  • @shravanatechzone8005
    @shravanatechzone8005 3 года назад

    How to execute 2saturday using conversion function???

  • @aruneshdillikar4633
    @aruneshdillikar4633 3 года назад

    what does DUAL stand for?
    what is the purpose just a learner asking .

    • @TechAcad
      @TechAcad  3 года назад +1

      DUAL is a built-in dummy table.
      And thank you so much for your great support and sharing!

  • @ibtsamsadiq5560
    @ibtsamsadiq5560 2 года назад

    thanks bro mush needed video

  • @yasminqureshi5296
    @yasminqureshi5296 3 года назад

    Thanks alot man, It was really helpful

    • @TechAcad
      @TechAcad  3 года назад

      Glad it helped
      And thank you so much for your great support and sharing our channel with your friends.

  • @shekhargunwant8347
    @shekhargunwant8347 4 года назад +3

    Trying british accent?(I'm not trying to tease u or whtever)

  • @MJgamer4U
    @MJgamer4U 3 года назад

    Thanks bro.... This is gonna help me.... ✌️

    • @TechAcad
      @TechAcad  3 года назад

      Glad to hear that

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

    You can take one table and take one column to convert to to number

  • @7504045535
    @7504045535 5 лет назад

    Client wants 28-02-19 convert into twentyeightfebruaryninteen..how can we do this??

    • @TechAcad
      @TechAcad  5 лет назад

      Hi
      We can do it using conversion with date format.
      Thanks for your great support.

  • @tlanhluachuteh174
    @tlanhluachuteh174 5 лет назад +1

    cant fully understand tonum, how can i use on a table

    • @TechAcad
      @TechAcad  5 лет назад

      Thank you my dear Friend for your great support.....
      We will have a detailed video about this topic soon.
      Thank you.......

  • @MiteshRathva
    @MiteshRathva 3 года назад

    Thank you

  • @supriyasugandhi9971
    @supriyasugandhi9971 2 года назад

    Please clear number function i didn't understand well

  • @lucassouzasilva6842
    @lucassouzasilva6842 5 лет назад +1

    thanks

    • @TechAcad
      @TechAcad  5 лет назад

      Thank you so much my dear Friend. .......

  • @rojenhasan2281
    @rojenhasan2281 3 года назад

    Thanks ♥️♥️

    • @TechAcad
      @TechAcad  3 года назад +1

      You're welcome 😊

  • @jangeashraf4226
    @jangeashraf4226 5 лет назад

    We can't able to see the results bro...

  • @nagabhushnambhushnam7534
    @nagabhushnambhushnam7534 2 года назад

    No calrity