Thanks Lutz once again gor your prompt help!

How can i use convert to make it like - 9/4/2008 9:00:01 AM

with this: SELECT CAST('2008-09-18T15:52:00.000-04:00' AS XML).value('xs:dateTime(.[1])', 'datetime')?

Thanks for your guidence!

Hi Lutz,

Thanks so much for your help!

When i alter to add columns as datatime datatype and update my both the columns, can you show me how to make date format...

Thanks so much for your help!

I think as per you example, i need to add two column and update the table.

Can you show me what will be the best idea...

Thanks so much!

Please see the following scripts for sample table and data:

Table Script:

CREATE TABLE [SSTrackTime](

[STrackID] [int] NOT NULL,

[Start] [nvarchar](50) NULL,

[Stop] [nvarchar](50) NULL,

CONSTRAINT [PK_SSTrackTime] PRIMARY KEY CLUSTERED

(

[STrackID] ASC

)WITH...

Hi,

If someone can help me out but my simple requirement is:

I have currently Date Data stored in two different format:

2009-11-09T15:53:44.2412829-07:00

2009-11-10T09:33:17.942678-07:00

2009-11-10T10:18:34.5119755-07:00

8/16/2009 6:53:19 PM

8/16/2009 6:53:19 PM

9/11/2009 9:06:41 AM

9/29/2009 3:12:07 PM

I want to...

Thanks once again.

I totally agree with you.

Is it any way Ican convert this into following format?

01/27/2009 22:32:37.740 or 2009/01/27 22:32:37.740

Thanks.

Sorry that i forgot to mention exact format:

I need in this format

DateColumn (Convert column)

2009-01-27T14:32:37.7389657-08:00 01/27/2009 22:32:37 PM

2009-01-27T14:32:37.7389657-08:00...

Thank you very much Lutz.

I tried to update my date filed with using your query but i have question that instead of in a yyyyMMDD format, how can i change...

Thanks Lutz.

The reason we created Varchar column instead of DateTime because we will be getting data in a different format and that contains date records like - 2009-11-13T15:01:00.2504758-05:00 and 9/24/2009...

Any help will be appreciated.

I am not 100% sure but you might need to MS Office tools as it will create the fiel on your server not your local m/c.

Or You might need to...

We don't use DTS.

The Ingrian appliance is a key management appliance. The appliance creates, holds, removes, and rotates the keys.

Thanks once again Andrew.

I will try it and let you know.

Thank you very much for your kind help!

Regards,

Pora

Check Ingrian, we use for Oracle and will be implementing for SQL server.