Date conversion to CCYYMMDD

• jim Edwards-308192

  Say Hey Kid

  Points: 680

  More actions

  March 8, 2006 at 8:44 am

  #93434

  thanks for the help, I did eventually find this in BOL. I'm just having trouble putting the syntax together. I'm new to T-SQL and waiting for some reference materials to arrive. Any good reference book suggestions would be greatly appreciated.

  convert(char(8),empper.birth_date,112) 

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 8, 2006 at 8:52 am

  #625436

  Assuming that the column holding your dates is a datetime datatype, you can convert it to a string and use a style parameter.

  SELECT CONVERT(CHAR(8), myDateColumn, 112) FROM ....

  ..will probably do the trick.

  Also, you can read more about display styles for dates under the subject CONVERT in BOL.

  /Kenneth