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

This video explains the use of Conversion Functions - Implicit & Explicit Function - To_Char, To_Number & To_Date in Oracle.
Practical Demonstrations with example of TO_CHAR, TO_NUMBER & TO_DATE.
For Learning More about Programming
Subscribe to My Channel: www.youtube.co...

[@SujithAbraham]

Great explanation.

[@DrParagShukla]

Thank You

[@abhijeetmazumdar9916]

Nice one sir....all clear

[@DrParagShukla]

Glad that it helps
Please share to needy learner

[@pateladarsh1463]

awesome concept clear !! Thank u so much sir

[@DrParagShukla]

Glad to hear that you liked it

[@prashgedam4803]

thanks sir i cleared my whole doubts..

[@DrParagShukla]

My Pleasure

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

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

[@nikunjvagadiya9358]

Very nice video sir 👍

[@DrParagShukla]

Thank You So Much

[@muhammadismailmehtab]

Nice sir

[@DrParagShukla]

Thank You

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

[@sushantdesai5305]

NICE VIDEO , please make more

[@DrParagShukla]

Thank You So Much

[@lalitsahoo840]

Sir can i contact u ?