Select GetDate() Just the month or year

Question

I wonder if someone can help me with getting JUST the month and year from SQL DB. Using the Select Getdate() Statement. If I need to use another one that would work that would be appretiated as well.

Thanks!

Answer 1

There are several ways to accomplish your task. In Books Online, look up [Functions], then [Date and Time Functions].

To retreive the current month as a number, use: 

SELECT month( getdate() )
SELECT datepart( month, getdate() )

To retreive the current month as a name, use:

SELECT datename( month, getdate() )

And to retreive the current year, use:

SELECT year( getdate() )
SELECT datepart( year, getdate() )

Answer 2

select month (getdate()),
       year(getdate())

Answer 3

Thank you so much guys! This will help a bunch!!! Is there a way to get just the year number (06) instead of (2006)?

I am looking for a date that should look like this: 1206 If it is possible.

 

Thanks!!

Answer 4

select year(getdate()) % 100

Answer 5

Thanks Waldorp!

Answer 6

Here is one option:

SELECT replace( right( convert( varchar(8), getdate(), 3 ), 5 ), '/', '' )

Answer 7

Waldrop wrote:

select year(getdate()) % 100

Careful with this one -it will drop the leading zero and return only

Answer 8

Arnie Rowland wrote:

Waldrop wrote: select year(getdate()) % 100 Careful with this one -it will drop the leading zero and return only

 

That was odd -just put 6 in square brackets...(No negativity meant! -LOL)

Answer 9

I brought a smile to me also!  If you want chars and need the leading zeroes:

select right ('0' + convert (varchar (2), year(getdate()) % 100), 2)

( Thank you for the smiles; they are welcome )

Dave  :-)

Answer 10

Thats fine. I realized that it would only give the 6 so this is what I did:

select '0'+CAST((year(getdate()) % 100) AS CHAR(1))

It is long winded, but it gives me what I need.

Answer 11

This one works relatively cleanly:

SELECT right( year( getdate() ), 2 )