convertion

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » convertion

convertion

Rate Topic

Display Mode

Topic Options

Author

Message

kumar99ms

Posted Tuesday, October 14, 2008 3:47 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 4:57 PM
Points: 74, Visits: 550

'19:12:43 CDT 05/23/2007' this is event_date but it is in varchar datatype.

How can we convert varchar datatype to date time datatype any body plz give suggestion

Post #585851

RBarryYoung

Posted Tuesday, October 14, 2008 3:55 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

The problem is that "CDT" in the middle. SQL Server does not have UTC data types (maybe in 2008?) and cannot do anything with a timezone. Are all of your times in the same timezone?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #585852

Matt Miller (#4)

Posted Tuesday, October 14, 2008 4:21 PM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,997, Visits: 13,941

Please don't double-post questions.

http://www.sqlservercentral.com/Forums/FindPost585845.aspx

It will have the opposite effect than what was intended, since you will tend to piss people off.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Post #585864

« Prev Topic | Next Topic »

Permissions