https://community.hpe.com/t5/server-management-systems/type-conversion-in-r-software-view/m-p/3424404#M7502 This is more of an SQL question rather than an HP SIM question, but I'm going to ask it, anyway.<BR /><BR />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.<BR /><BR />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.)<BR /><BR />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.<BR /><BR />Thanks in advance . . . Wed, 17 Nov 2004 14:33:22 GMT Raymond Kim 2004-11-17T14:33:22Z https://community.hpe.com/t5/server-management-systems/type-conversion-in-r-software-view/m-p/3424404#M7502 This is more of an SQL question rather than an HP SIM question, but I'm going to ask it, anyway.<BR /><BR />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.<BR /><BR />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.)<BR /><BR />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.<BR /><BR />Thanks in advance . . . Wed, 17 Nov 2004 14:33:22 GMT https://community.hpe.com/t5/server-management-systems/type-conversion-in-r-software-view/m-p/3424404#M7502 Raymond Kim 2004-11-17T14:33:22Z