Printing date without timestamp

• frcoley

  Valued Member

  Points: 65

  More actions

  August 12, 2010 at 10:02 am

  #239013

  I have the below code:

  getdate()-2 but it is not pulling any data back because it pulls back the timestamp (2010-08-10 12:02:01.330)

  I need getdate() to print as 2010-08-10

  Any assistance on this is greatly appreciated!!!

  Thanks@

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  August 12, 2010 at 10:06 am

  #1206157

  try this:-

  select convert(char(8),getdate(),102)

  ----------
  Ashish