Date Variable - YYYYMMDD

[jconway]

I'm trying to create today's date as a variable in the format YYYYMMDD. In my expression I'm getting errors with everything I try. I've tried:

cast(convert(varchar(12), getdate(), 112) as int)

select cast(convert(varchar(12), getdate(), 112) as int)

select FullDate
from dim_Date
where DateKey = cast(convert(varchar(12), getdate(), 112) as int)


Can anyone tell me what I'm missing here? It may be quite obvious which is why I'm asking for advice.

Thanks!

 

[jconway]

SOLUTION:

(DT_STR,4,1253)YEAR(GETDATE()) + RIGHT("0" + (DT_STR,2,1253)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1253)DAY(GETDATE()),2)

 

[drlex]

How about

CONVERT(CHAR(8), GETDATE(), 112)

?

soi la, soi carré