Re: < and > for datetime

Sarah Officer wrote:
> Hi all,
>
> I'm trying to find less than and greater than functions for
> datetime types. It doesn't look the the time interval operators
> would be appropriate, but I haven't found anything else in the
> docs. Here's my snippet of plpgsql which fails:
>
> select count(*) into rescount
> from currentresults cr, masters m
> where cr.ben = new.ben
> and m.mi_id = cr.mi_id
> and m.idate > mydate;
>
> rescount & mydate are variables. How do I compare dates? I'd be
> glad to read the documentation if I could find the right page.

\do shows:

<= |datetime |datetime |bool |less-than-or-equal
<> |datetime |datetime |bool |not equal
= |datetime |datetime |bool |equal
> |datetime |datetime |bool |greater-than
< |datetime |datetime |bool |less-than

Thus, your WHERE-clause should be proper.

Regards,

Joey

--
This is Linux Country. On a quiet night, you can hear Windows reboot.