I tried all bracket combinations before emailing. It doesn't seem to be
a problem with the brackets.
Thanks
Eno
[EMAIL PROTECTED] wrote:
Try:
select count(*) from table1
where (timestamp >13448180261410868 and timestamp <= 13448182164507680);
not:
select count(*) from table1
where ((timestamp >13448180261410868) and (timestamp <=
13448182164507680));
Regards.
rayB
************** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING
*************
******************* Confidentiality and Privilege Notice
*******************
This e-mail is intended only to be read or used by the addressee. It is
confidential and may contain legally privileged information. If you are not the
addressee indicated in this message (or responsible for delivery of the message
to such person), you may not copy or deliver this message to anyone, and you
should destroy this message and kindly notify the sender by reply e-mail.
Confidentiality and legal privilege are not waived or lost by reason of
mistaken delivery to you.
Qantas Airways Limited
ABN 16 009 661 901
Visit Qantas online at http://qantas.com
****************************************************************************
--
Eno Thereska
-------------------------------------------------
Carnegie Mellon University
Parallel Data Laboratory
CIC Building Cube 2221-D
5000 Forbes Ave Pittsburgh, PA 15213
Tel: 412-268-5908
