Writing a date function

[newtosql]

Hi,

I think I need to write a function to avoid using this query over and over again.

CAST(DATEPART(YEAR,getdate()) AS VARCHAR) +
REPLICATE('0',2-LEN(CAST(DATEPART(MONTH,getdate()) AS VARCHAR))) +
CAST(DATEPART(MONTH,getdate()) AS VARCHAR) +
REPLICATE('0',2-LEN(CAST(DATEPART(DAY,getdate()) AS VARCHAR))) +
CAST(DATEPART(DAY,getdate()) AS VARCHAR)

Any ideas?

 

[MaffewW]

try this

select convert (varchar,getdate(),112)

BOL says its yymmdd but it is actually yyyymmdd

Matt

Brighton, UK

 

[rajeevnandanmishra]

Hi newtosql,

there is an in-built function you can use as :
--------
select convert(varchar,getdate(),112)
--------

this will give you the same result as of your query.

If it is not what you wanted, then do post your reply.


Raj