October 14, 2008 at 3:47 pm
'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
October 14, 2008 at 3:55 pm
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?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 14, 2008 at 4:21 pm
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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply