Type conversion in R_Software view

[Raymond Kim]

This is more of an SQL question rather than an HP SIM question, but I'm going to ask it, anyway.

The R_Software view contains a date field, but it is NOT in standard date format! (For some reason, it's a nvarchar field.) Because this field is of type datetime in my DB (which is what it was in CIM 7, which my DB emulates), I have to convert it over.

Does anyone know of an EASY (key word) way to convert this field over to type datetime? I tried CAST and CONVERT, but it doesn't like the format (because of the way HP SIM formats the date/time in this field.)

I can probably figure out a way to do it programmitcly (sp?), but I'm hoping I can save myself a lot of time and effort.

Thanks in advance . . .