How to Insert - (hyphens) Into a Date String

[JohnBates]

hi,

This char date is like 20040214 with no dashes, slashes.

If I can insert dashes to get 2004-02-14 then it will convert to a DateTime data type in the DTS transformation task.

Just need a little tip on how to insert the dashes with code.

Thanks, John

 

[JohnBates]

... and I should have explained that I actually want to update the row with the new char value of 2004-02-14 for example.

John

 

[dbomrrsm]

Update table
SET yourfield = LEFT(Yourfield,4)+-+SUBSTRING(Yourfield,5,2)+-+Right(Yourfield,2)

You could use substring in all three occasions above but thought would put in left and right to show their use.

Substring explained is the field you are interested in the start position of what you want and the length of what you want.

Hope this helps.

DBomrrsm

 

[Connatic]

Or you could use this:

declare @Date as CHAR(10)

SET @Date = CONVERT(CHAR(10),CONVERT(DATETIME,'20040214'),105)

PRINT @Date

The above example will show you how it works, but you will want it to look like

SET yourfield = CONVERT(CHAR(10),CONVERT(DATETIME,yourfield),105)