From: Andrew Moore
Date: May 12 2011 3:10pm
Subject: Re: operation with dates
List-Archive: http://lists.mysql.com/mysql/224989
Message-Id: <BANLkTi=pUZUAEaayAcbhEN4YGBrFt-_Czg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf305b091a921f3904a3159748

--20cf305b091a921f3904a3159748
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Rocio,

there are specific date functions that you need to learn to allow you to
complete this kind of query. Please check out the MySQL documentation for
this.

HTH

Andy

On Thu, May 12, 2011 at 4:05 PM, Rocio Gomez Escribano <
r.gomez@stripped> wrote:

> Hello! I=92m trying to subtract two dates in my consult, but I don=92t ge=
t it,
> I did:
>
>
>
>
>
>
>
> mysql> select userID from user where (userPaymentDate - now()) < 365 ;
>
>
>
>
>
> It didn=92t work. Do you know how to do it? Thank you so much!
>
>
>
> Regards
>
>
>
> *Roc=EDo G=F3mez Escribano*
>
> r.gomez@stripped <r.sanchez@stripped>
>
>
>
> [image: Descripci=F3n: cid:image002.jpg@stripped]
>
> Pol=EDgono Campollano C/F, n=BA21T
>
> 02007 Albacete (Espa=F1a)
>
> Tlf:967-504-513  Fax: 967-504-513
>
> www.ingenia-soluciones.com
>
>
>

--20cf305b091a921f3904a3159748--