max date

• znkin

  Old Hand

  Points: 382

  More actions

  March 11, 2005 at 6:17 am

  #362230

  I have 2 datetime columns in my db table. I need to find out a single maximum datetime value from this table from these 2 columns

  Thanks a lot

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  March 11, 2005 at 6:29 am

  #546597

  Select max(dt)a from ( select max(Date1) dtfrom ads_tariff union select max(Date2) dt from ads_tariff) b

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/