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 :)
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
Man u r excellent . U r practical wise commend execution is really amazing. Thank u so much....
Very nice
Simple nd clean explanations.... Good
Thank you so much 🙂
Tqs aa lot 💖💖💖
My online professor🙏
So nice of you
great
Thank you sir, i really needed this for my online class.
Glad it was helpful!
And thanks for your great support and sharing!
thanks bro mush needed video
Glad it helped
Thanks bro.... This is gonna help me.... ✌️
Glad to hear that
Thanks alot man, It was really helpful
Glad it helped
And thank you so much for your great support and sharing our channel with your friends.
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 :)
Yes they do
@@TechAcad bro u didnt answer what he asked lol
You can take one table and take one column to convert to to number
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
what does DUAL stand for?
what is the purpose just a learner asking .
DUAL is a built-in dummy table.
And thank you so much for your great support and sharing!
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.
Yes, it is possible.
Thanks ♥️♥️
You're welcome 😊
Thank you
You're welcome
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)..???
Trying british accent?(I'm not trying to tease u or whtever)
How to execute 2saturday using conversion function???
cant fully understand tonum, how can i use on a table
Thank you my dear Friend for your great support.....
We will have a detailed video about this topic soon.
Thank you.......
Client wants 28-02-19 convert into twentyeightfebruaryninteen..how can we do this??
Hi
We can do it using conversion with date format.
Thanks for your great support.
thanks
Thank you so much my dear Friend. .......
Please clear number function i didn't understand well
We can't able to see the results bro...
No calrity