Date functions 1

[cisco999]

How do I convert this:
02/13/2003 to 03^02^13

I've used the str & datepart functions to get:
2003^ 2^ ^13
Almost there but not quite.

Appreciate your help!

 

[Discord]

this should work

RIGHT(CAST(Year(CreateDate) AS VARCHAR), 2)+'^'+
CASE WHEN Month(CreateDate) <= 9 THEN '0' ELSE '' END+ CAST(Month(CreateDate) AS VARCHAR)+'^'+
CASE WHEN Day(CreateDate) <= 9 THEN '0' ELSE '' END+ CAST(Day(CreateDate) AS VARCHAR)

 

[cisco999]

Thanks! That worked! You are bad to the bone!
Was a lot easier in Oracle though...

 

[JamesLean]

This is an alternative method:

REPLACE(CONVERT(varchar(8), getdate(), 2), '.', '^')

Using the CONVERT function with style 2 gets the date in yy.mm.dd format. Then you use REPLACE to change the symbols. --James

 

[cisco999]

Thanks JamesLean, that worked great!