Query to find day of given date using to_char and to_date - Practical Demonstration - Oracle SQL

This video demonstrates how to find the day of given date. User can enter the date and based on date query returns the day.
Practical Demonstration to find day of given date. In this video to_char and to_date is explained with example.
For example: If user enters the date 26th Dec 2021 then output should be Sunday
For Learning More about Programming
Subscribe to My Channel: www.youtube.co...

[@sanjanakhatri8939]

Why it gives the error of invalid number..can u please tell the reason

[@DrParagShukla]

Post your query here
I will correct it

[@rutujakakde6226]

Hello, I am getting this error ora-01858 a non-numeric character was found where a numeric was expected

[@DrParagShukla]

Write your select statement.
Will correct it