Date reformat question for the group

I hope I am posting this in the correct group, but if not please tell me
the proper place. I am more of an admin type than a developer and am
having a problem I have been unable to code around. In short, what I
want to do is convert today's date and time into a series of local
numerical character variables

YYYY
MM (with a leading 0 if LT 10)
DD (with a leading 0 if LT 10)
HH (24-hour format)
SS

This format is equivalent to a CONVERT function style code of 120 with
the separators removed.

Tried various combinations of SUBSTRING and CONVERT functions, but they
did not work. For example the SUBSTRING can only handle CHAR/VARCHAR
type data. Then the GETDATE() function represents the internal DATETIME
format as

MMM DD YYYY HH:MMAM or
MMM DD YYYY HH:MMPM

where the leading D=0 and H=0 are omitted. The YEAR and DAY functions
work but also omit any leading zero's and there is no corresponding
HOURS or MINUTES function

Any coders out there with a suggested solution as to how I can do this?
I've run out of ideas and BOL hasn't helped.

--
Graham (Pete) Berry
PeteBerry.TakeThisOut@CalTech.edu

Hi,

Assuming you're using SQL Server 2005, have you tried using the DATEPART
function?

Jonathan



Graham (Pete) Berry wrote:
> I hope I am posting this in the correct group, but if not please tell me
> the proper place. I am more of an admin type than a developer and am
> having a problem I have been unable to code around. In short, what I
> want to do is convert today's date and time into a series of local
> numerical character variables
>
> YYYY
> MM (with a leading 0 if LT 10)
> DD (with a leading 0 if LT 10)
> HH (24-hour format)
> SS
>
> This format is equivalent to a CONVERT function style code of 120 with
> the separators removed.
>
> Tried various combinations of SUBSTRING and CONVERT functions, but they
> did not work. For example the SUBSTRING can only handle CHAR/VARCHAR
> type data. Then the GETDATE() function represents the internal DATETIME
> format as
>
> MMM DD YYYY HH:MMAM or
> MMM DD YYYY HH:MMPM
>
> where the leading D=0 and H=0 are omitted. The YEAR and DAY functions
> work but also omit any leading zero's and there is no corresponding
> HOURS or MINUTES function
>
> Any coders out there with a suggested solution as to how I can do this?
> I've run out of ideas and BOL hasn't helped.
>