Oracle || Date functions Part-1 by dinesh

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

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

  • @jayanthi3112
    @jayanthi3112 4 года назад +2

    Easily you taught date functions, I learned thank you sir...

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

    Thanks for the explanation...your about the only video on internet 👍

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

      Hello The Event. For Oracle all videos,
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627, 7207212427/28

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

    Very nice teaching sir thankful

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

      For first day of month is it used next_day syntax or first_day

  • @kanikabhalla801
    @kanikabhalla801 7 лет назад +1

    Hello Sir. please release video on Conversion and general function. thanks alot !

  • @AG-fj6qe
    @AG-fj6qe 5 лет назад +2

    Select trunc ( add_months ( hire_date, sysdate)/12) from emp only gives total exp not what you have shown sir...Am I mistaken?

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

      Hello Geek.
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627, 7207212427/28

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

    instead of trunc, can we use round of function

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

      Hello Vignesh.
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627, 7207212427/28

  • @rajasekharroyal4000
    @rajasekharroyal4000 7 лет назад +1

    Why should we maintain same symbol in to_date function between argument-1 and 2
    SQL> select to_date('11:05:2017','mm/dd/yyyy') out from dual;
    OUT
    ---------
    05-NOV-17

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

      u can use any seperator, it will work

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

    How to convert timestamp in db2to oracle and store in date format

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

      Hello Chetana.
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627, 7207212427/28

  • @ShahbazKhan-ks9mv
    @ShahbazKhan-ks9mv 5 лет назад +1

    How to display in week between two date

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

      Hello Shahbaz.
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627, 7207212427/28

  • @kirankumarbelagali3741
    @kirankumarbelagali3741 6 лет назад

    please upload other date functions videos please

    • @DurgaSoftwareSolutions
      @DurgaSoftwareSolutions  6 лет назад

      Hello Kiran.
      Plz contact our online team durgasoftonlinetraining@gmail.com or call us on this number +918885252627,7207212427/28