SQL-Lecture-20 (Conversion Functions - Implicit & Explicit Function - To_Char, To_Number & To_Date)

[@SujithAbraham]

Great explanation.

[@DrParagShukla]

Thank You

[@abhijeetmazumdar9916]

Nice one sir....all clear

[@DrParagShukla]

Glad that it helps
Please share to needy learner

[@muhammadismailmehtab]

Nice sir

[@DrParagShukla]

Thank You

[@prashgedam4803]

thanks sir i cleared my whole doubts..

[@DrParagShukla]

My Pleasure

[@pateladarsh1463]

awesome concept clear !! Thank u so much sir

[@DrParagShukla]

Glad to hear that you liked it

[@nishanthkumar4743]

Hey Parag, Great video. However, i have question on the scenario discussed at 40th minute in video.
The scenarios is to find the classes between 10 AM and 11 PM
The soultion given in the video is "between '10:00:00' and '11:00:00'"
My questions:
1) Do we need to give "between '10:00:00' and '23:00:00'"
2) And the TO_CHAR output is character ryt? does it accept the between filter with single quotes?

[@DrParagShukla]

Thank you for asking wonderful question
It is between 10 AM to 11 AM.
If it is 10 AM to 11 PM then you are right we need to write '10:00:00' and '23:00:00'
Yes, to_char is used to convert date or numeric to character. Between and operator will work for any data type including date, char or numerical. So, it will accept single quotation.

[@perumallashureshh1925]

Superb explanation... Thanks alot

[@DrParagShukla]

My Pleasure

[@perumallashureshh1925]

@@DrParagShuklaji please provide videos on snowflake ❄️ software

[@poongodibanu2036]

Pls provide plsql function , package, trigger, ref cursor practical sir

[@nikunjvagadiya9358]

Very nice video sir 👍

[@DrParagShukla]

Thank You So Much

[@Sam-q4p]

Hi sir , what will be the query for the extension of the probation period of employee after the last date of work is over.

[@Fuell_For_Dreams]

NICE VIDEO , please make more

[@DrParagShukla]

Thank You So Much

[@lalitsahoo840]

Sir can i contact u ?