By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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?
Oracle does not have a datepart function. But the syntax:
Datepart(month,abc_date) = '03'
can be converted to the following in the Oracle date routine:
to_char(abc_date,'mm') = '03'