Get Month Name With Year Based On Number In Sql

Get Month Name With Year Based On Number In Sql. Select fn_month_name_to_number (*columnname*) as month_no from *tablename* have a good day! Select fn_month_name_to_number ('february') as month_no this query will return 2 as month number.

November 2018
November 2018 from gisqas.blogspot.com

You can pass values from a column as parameters to the function. By the way, another note to the reader: You can also get a month enum object rather than a mere integer number.

You Can Pass Values From A Column As Parameters To The Function.


See enum tutorial by oracle. Select fn_month_name_to_number ('february') as month_no this query will return 2 as month number. You can also get a month enum object rather than a mere integer number.

Select Fn_Month_Name_To_Number (*Columnname*) As Month_No From *Tablename* Have A Good Day!


By the way, another note to the reader:

Comments

Popular posts from this blog

Water That Effect Cement Ratio On Strength And Compatibility

2019 European Youth Olympic Winter Festival

Hoki Kelayakan Akhir Olimpik 2020