Datepart function in Oracle
I want to use the datepart function to get the month of my variable. Is this allowed in Oracle or am I off on the syntax?
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Datepart(month,ABC_Date)Is this allowed in Oracle or am I off on the syntax?
Datepart(month,abc_date) = '03'can be converted to the following in the Oracle date routine:
to_char(abc_date,'mm') = '03'