Between and miliseconds (timestamps) - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Between and miliseconds (timestamps)
Date
Msg-id 55c095e90611100628m1322eea5jeeca3a94d90e1eb1@mail.gmail.com
Whole thread Raw
Responses Re: Between and miliseconds (timestamps)
List pgsql-sql
Hi list,<br /><br />I noticed that when we use the keyword between in SQL statements we must considerer all the
milisecondswith 6 digits.<br /><br />I would like to know if we want to make a day selection we must use allways the
maxof possibilities like: <br /><br /><br />select * from base.table<br />where when<br />between <br />'2006-09-06
00:00:00.000000'<br />and<br />'2006-09-06 23:59:59.999999'<br />order by 2<br clear="all" /><br />Is there a simplest
wayor not ?<br /><br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a> 

pgsql-sql by date:

Previous
From: "Stuart Brooks"
Date:
Subject: Constraint on multicolumn index
Next
From: "A. Kretschmer"
Date:
Subject: Re: Between and miliseconds (timestamps)