Extract Monthly report but Different DATE Format data into SQL server 2005 Database

• LutzM

  SSC Guru

  Points: 107049

  More actions

  March 30, 2010 at 2:29 pm

  #1142694

  poratips (3/30/2010)

  ---

  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 like 9/4/2008 9:00:01 AM

  instead of 2009-10-13 21:42:24.223

  thanks,

  Poratips

  See my post dated 3/18/2010 11:26:47 PM. (use CONVERT() to format the appearance of the column in a query, internally it will remain integer anyway...)

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• poratips

  Hall of Fame

  Points: 3994

  More actions

  March 31, 2010 at 12:45 pm

  #1143368

  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!