Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

convertion Expand / Collapse
Author
Message
Posted Tuesday, October 14, 2008 3:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Tuesday, October 14, 2008 3:55 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:14 AM
Points: 9,294, Visits: 9,483
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
Posted Tuesday, October 14, 2008 4:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:51 PM
Points: 7,105, Visits: 15,444
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 »

Add to briefcase

Permissions Expand / Collapse