Inserting todays date into a column

• paul welsh

  SSC Veteran

  Points: 204

  More actions

  August 30, 2005 at 7:45 am

  #165864

  HI,

   

  I am inserting info from a join query into a single table. There is nowhere in the join results that actually has todays date. In the destination table I have added a column so that I can insert todays date. What syntax do I need to use to add todays date to a specific column of a table?

   

  thanks,

   

  Paul

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 30, 2005 at 7:48 am

  #586131

  You can add a default to that column (GetDate()), so you wouldn't have to specify it in the insert/select.

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  August 31, 2005 at 12:48 am

  #586363

  GetDate() will return the current date and time.

  If you want just the date without the time:

  CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME)

  ---

  Julian Kuiters
  juliankuiters.id.au

• gbn

  SSCertifiable

  Points: 6429

  More actions

  August 31, 2005 at 4:16 am

  #586397

  DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) keeps the date only converison numeric

  Try it over a dummy table of 10000 rows etc... quicker

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 31, 2005 at 6:45 am

  #586432

  Check this out for more details on performance conversions :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=215358&p=2

• Michael Mihalik

  Old Hand

  Points: 355

  More actions

  August 31, 2005 at 6:54 am

  #586440

  If you want just the date, use an ODBC canonical function

  select {fn CURRENT_DATE()} AS 'date only'

  or

  SELECT {fn CURRENT_TIMESTAMP()} AS 'Timestamp'

  See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcscalar_functions.asp for more information on ODBC functions.