string to datetime

[Tess Gear]

There is a citydate field with string data type in SQL 2K,
2004-04-04 20-45-08. I'd like to convert it to a datetime data type
which should be 12/07/2004 1:34:30PM.

Please help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Andy Williams]

Re: string to datetime

Tess,

SELECT CAST(LEFT(cityd ate, 10) + ' ' + REPLACE(RIGHT(c itydate, 8), '-', ':')
AS datetime)

-Andy

"Tess Gear" <ted_gear@hotma il.com> wrote in message
news:1102445339 .2e88aafa08b0c6 8e9aafb702cec1d 2fb@teranews...[color=blue]
> There is a citydate field with string data type in SQL 2K,
> 2004-04-04 20-45-08. I'd like to convert it to a datetime data type
> which should be 12/07/2004 1:34:30PM.
>
> Please help.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]