List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 13 2011 2:46pm
Subject:Re: operation with dates
View as plain text  
In the last episode (May 12), Halßsz Sßndor said:
> >>>> 2011/05/12 13:06 -0500, Dan Nelson >>>>
> In the last episode (May 12), Rocio Gomez Escribano said:
> > I found it, 
> > 
> > mysql> select userID from user where datediff(now(), userPaymentDate)<
> 365;
> 
> This can be made more readable by using mysql's INTERVAL syntax. 
> <<<<<<<<
> And less portable....

Datediff isn't portable, either :)

-- 
	Dan Nelson
	dnelson@stripped
Thread
operation with datesRocio Gomez Escribano12 May
Re: operation with datesAndrew Moore12 May
  • RE: operation with datesRocio Gomez Escribano12 May
    • Re: operation with datesDan Nelson12 May
      • Re: operation with dateshsv13 May
        • Re: operation with datesDan Nelson13 May
          • Re: operation with dateshsv14 May