List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:April 1 2006 12:32pm
Subject:Getting number days between 2 dates
View as plain text  
Hello,

I'm sure this is a simple query but haven't come up with a good approach. Need 
to get the number of days between two dates. IE: today's date: (2006-04-01 - 
2006-03-05)
need to calculate the number of days between these dates.. what is the best 
query statement to accomplish this?

TIA,

Mike(mickalo)Blezien
===============================
Thunder Rain Internet Publishing
Providing Internet Solution that Work
=============================== 

Thread
Getting number days between 2 datesMike Blezien1 Apr
  • Re: Getting number days between 2 datesJorrit Kronjee1 Apr
  • Re: Getting number days between 2 datesMike Blezien1 Apr
    • Re: Getting number days between 2 datesJorrit Kronjee1 Apr
  • Re: Getting number days between 2 datesRhino1 Apr
    • Re: Getting number days between 2 datesmysql1 Apr
  • Re: Getting number days between 2 datesMike Blezien1 Apr
    • RE: Getting number days between 2 datesJim MacDiarmid4 Feb
      • Re: Getting number days between 2 datesDuncan Hill5 Feb
        • RE: Getting number days between 2 datesJerry Schwartz5 Feb