CAST Date to Character

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  October 16, 2013 at 3:39 am

  #283903

  Hi,

  I have a field that is DATE format -

  contains either "NULL" which shows as "1900-01-01 00:00:00.000"

  or valid dates of "2013-10-16 00:00:00.000"

  I would like to cast this as a char so that I get " " or "2013-10-16"

  I have tried to

  CAST ( tableFieldDate as varchar(30) )

  but get "Jan 1 1900 12:00AM"

  should I be CAST and then embedding a date format ?

  Thanks in advance

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.

• Stuart Davies

  SSCoach

  Points: 19505

  More actions

  October 16, 2013 at 3:43 am

  #1658828

  Try this :-

  convert(CHAR(10), getdate() ,120)

  I think it might suit what you're trying to do

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  October 16, 2013 at 4:05 am

  #1658832

  Brilliant - thank you.

  I do like Simple answers

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.

• Stuart Davies

  SSCoach

  Points: 19505

  More actions

  October 16, 2013 at 1:53 pm

  #1659065

  You're welcome - I try to keep everything simple - it makes life easier for the next guy!

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx