Fun With Dates

[greese]

I am exporting the date along with results from my table my table but need it in the format yymmdd 12/17/2003 becomes 031203.

To test this out, i have the following:

Declare @dtYear varchar(2)
Declare @dtMonth varchar (2)
Declare @dtDay varchar (2)

set @dtYear = right (Datepart(yyyy, Getdate()+22),2)
set @dtmonth = Datepart (mm, Getdate()+22)
set @dtDay = datepart (dd, Getdate()+22)

Select @dtYear as [Year],
 @dtMonth as [Month],
 @dtDay as [Day];

My results are:

Year Month Day  
---- ----- ---- 
04   1     8

how do i get the leading zero to drop in there for the date? When i concatenate it together i get 0418 instead of 040108

I have tried searching for something on this but came up empty.

Any ideas are greatly appreciated.

G Reese

 

[dickiebird]

Try:-

set @dtmonth=right("00" + Datepart (mm,Getdate()+22),2)

Dickie Bird (-)))

 

[bdreed35]

This will simplify your code and give you the result you are looking for:

Select CONVERT(char(6),GetDate()+22,12)

~Brian

 

[NickW2]

For yymmdd format, try:-

select convert(char(6),getdate(),12)

 

[greese]

perfect.

Except i made a mistake. It was supposed to be mmddyy

Does the same method handle that as well?

Thanks!

G Reese

 

[bdreed35]

Check out the CONVERT function in Books Online. The 12 I used in my CONVERT function is the style property. There are a whole bunch of styles to choose from. I think that you will want to use a style of 10. THis leaves you with mm-dd-yy. You can use the Replace function to get rid of them.

Select REPLACE(CONVERT(varchar(8),GetDate()+22,10),'-','')

~Brian

 

[greese]

Thanks! That did the trick and i think am now on the right path.

I knew there had to be an easier way then how i was doing it.

G Reese