From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Between and miliseconds (timestamps)
Date: Fri, 10 Nov 2006 12:28:53 -0200
Message-ID: <55c095e90611100628m1322eea5jeeca3a94d90e1eb1@mail.gmail.com> (raw)
Hi list,
I noticed that when we use the keyword between in SQL statements we must
considerer all the miliseconds with 6 digits.
I would like to know if we want to make a day selection we must use allways
the max of possibilities like:
select * from base.table
where when
between
'2006-09-06 00:00:00.000000'
and
'2006-09-06 23:59:59.999999'
order by 2
Is there a simplest way or not ?
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias.rocha@gmail.com
Subject: Re: Between and miliseconds (timestamps)
In-Reply-To: <55c095e90611100628m1322eea5jeeca3a94d90e1eb1@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox