DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: compare two dates

  1. 02-04-2003, 04:38 PM #1
    thien
    thien is offline Junior Member
    Join Date
    Feb 2003
    Posts
    1

    compare two dates

    I want to compare two dates and check whether or not date1 is more than 55 days older than date2. What is the best way to do this? I've looked into the months_between, and that doesn't give me exactly what I want.

    Any suggestions would be appreciated.
    Reply With Quote Reply With Quote
  2. 02-04-2003, 04:45 PM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    date2 - date1 > 55
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width