Extarcting the first month of year

Database

Extarcting the first month of year

hello All,

Could anyone please help me on building the query in extracting the first month of any given year.

eg:

if the user enters Apr `09 then the result should be Jan `09
If the user enters Dec `10 the the result should be Jan `10.

Sincirely appreciate your assiatance in this regard.
2 REPLIES
Enthusiast

Re: Extarcting the first month of year

how you want the output in Date data type or only year and month ?

Re: Extarcting the first month of year

i found the solution.

by performing a cross join in a table which is already existing in the table.

Thanks all for looking into this