Prev: Word page templates in SSRS, and creating a summary page in SSRS
Next: <resource-list> Deadlock graph interpretation
From: Don McCullers on 29 Apr 2010 15:36
Greetings!

I need to convert a number of time values that look like "1/6/2010 ¿ÀÈÄ
10:28:51" and "1/7/2010 ¿ÀÀü 7:45:00" to DateTime values. Needless to say,
it's not working. I'm pretty sure that the reason is that the "¿ÀÈÄ" and
"¿ÀÀü" are the Korean equivilents of "AM" and "PM". Can anyone tell me which
is which?

Thanks!
Don
From: Uri Dimant on 2 May 2010 04:13
Hi
Can you use REPLACE those letters with '' and then convert to date time ?
select cast('1/7/2010 �??? 7:45:00' as datetime)

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

select cast(replace('1/7/2010 �??? 7:45:00','�???','')as datetime)





"Don McCullers" <DonMcCullers(a)discussions.microsoft.com> wrote in message
news:C6792808-D6D2-4BB4-84FD-0E65744C028F(a)microsoft.com...
> Greetings!
>
> I need to convert a number of time values that look like "1/6/2010 �???
> 10:28:51" and "1/7/2010 �??? 7:45:00" to DateTime values. Needless to say,
> it's not working. I'm pretty sure that the reason is that the "�???" and
> "�???" are the Korean equivilents of "AM" and "PM". Can anyone tell me
> which
> is which?
>
> Thanks!
> Don


 | 
Pages: 1
Prev: Word page templates in SSRS, and creating a summary page in SSRS
Next: <resource-list> Deadlock graph interpretation