CONVERT SQL'S GETDATE() TO DB2 HUNDRED YEAR DATE

• slindojr

  SSC Veteran

  Points: 299

  More actions

  March 5, 2008 at 6:25 pm

  #203916

  I am downloading a table form AS400/DB2 and must convert GetDate() in T-SQL to hundred year date so that I may query the downloaded table.

  Does anyone have a solution?

  Thanks,

  Stan

• Jay1234

  SSCommitted

  Points: 1624

  More actions

  March 6, 2008 at 3:43 am

  #785848

  I think you want to capture number of days between 1900/01/01 and another date which is in your table. you can use datediff function.

  datediff(dd,startdate,enddate)

  for example -

  select datediff(dd,'1900/01/01','2008/03/05') gives you 39510

  for more - http://msdn2.microsoft.com/en-us/library/ms189794.aspx

• slindojr

  SSC Veteran

  Points: 299

  More actions

  March 6, 2008 at 9:10 am

  #786086

  Thank you very much, Jay. I will try your suggestion today!