Re: [postgresql-it] query lenta

  • From: Chris Mair <chris@xxxxxxxx>
  • To: postgresql-it <postgresql-it@xxxxxxxxxxxxx>
  • Date: Mon, 22 Jan 2007 21:31:36 +0100

anziche
    to_date(datins, 'yyyy-mm-dd') >= '2000-01-01'::date AND
    to_date(datins, 'yyyy-mm-dd') <= '2007-01-22'::date AND

proverei
    dateins between '2000-01-01 00:00:00' and '2007-01-22 00:00:00'
                                                ^^^^^^^^^^^^^^^^^^^^^
                                  intendevo     '2007-01-22 24:00:00'


Bye,
Chris.


Other related posts: