DatePart

I am stuck with a particular Datepart Query
Declare @.day char(2)
Declare @.month char(2)
Declare @.year char(4)
Declare @.date char(8)
set @.day = (select DATEPART(day, GETDATE()))
set @.month = (select DATEPART(month, GETDATE()))
set @.year = (select DATEPART(year, GETDATE()))
set @.date = (select @.day + @.month + @.year)
The results for this query are displayed as follows
151 2004
I actually need to pad 1 with 01 and also repeat the same for the Day. So
if the date was 1st Jan 2004 then my current query would return
1 1 2004 (require 01012004)
How do I do this? Any help appreciated.
Thanks Sarahnot sure if this is the 'correct' way but I notice you are declaring the
variables as strings, so this should work:
declare @.day char(8)
set @.day = (select DATEPART(month, GETDATE()))
if len(@.day) < 2
set @.day = '0' + @.day
Select @.day
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||SELECT CONVERT(char, getdate(), 103)
results in 15/01/2004
if you don't want the /
try
SELECT REPLACE( CONVERT(char, getdate(), 103), '/', '')
>--Original Message--
>I am stuck with a particular Datepart Query
>Declare @.day char(2)
>Declare @.month char(2)
>Declare @.year char(4)
>Declare @.date char(8)
> set @.day = (select DATEPART(day, GETDATE()))
> set @.month = (select DATEPART(month, GETDATE()))
> set @.year = (select DATEPART(year, GETDATE()))
> set @.date = (select @.day + @.month + @.year)
>The results for this query are displayed as follows
>151 2004
>I actually need to pad 1 with 01 and also repeat the same
for the Day. So
>if the date was 1st Jan 2004 then my current query would
return
>1 1 2004 (require 01012004)
>How do I do this? Any help appreciated.
>Thanks Sarah
>
>.
>