Skip site navigation (1) Skip section navigation (2)

Can someone tell me why this statement is failing?

From: P A <patkins2474(at)yahoo(dot)com>
To: pete(at)tkins(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Can someone tell me why this statement is failing?
Date: 2004-04-19 20:31:50
Message-ID: 20040419203150.77559.qmail@web41112.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
Can anyone tell me why this SQL statement is not
matching with the row from the table below? I think
I'm going mad!

#####################################
SQL Statement
#####################################

SELECT * FROM t_bell_schedule WHERE calendar_day =
'2004-04-12' AND start_time_minutes >= '1082374200'
AND end_time_minutes <= '1082375100';

#####################################
Current DB Data to match
#####################################

 calendar_day | period_letter | start_time_minutes |
end_time_minutes
--------------+---------------+--------------------+------------------
 2004-04-12   | B             |         1082374440 |  
    1082377320

#####################################
DB Structure 
#####################################

       Column       |            Type             |   
                               Modifiers
--------------------+-----------------------------+--------------------------------------------------------------------------------
 bell_schedule_uid  | integer                     |
not null default
nextval('public.t_bell_schedule_bell_schedule_uid_seq'::text)
 calendar_day       | date                        |
 period_letter      | character varying(4)        |
 period             | character varying(4)        |
 start_time         | time without time zone      |
 end_time           | time without time zone      |
 total_minutes      | integer                     |
 activestatus       | integer                     |
 datecreated        | timestamp without time zone |
 datemodified       | timestamp without time zone |
 start_time_minutes | integer                     |
 end_time_minutes   | integer                     |


Cheers,
Pete



	
		
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25
http://photos.yahoo.com/ph/print_splash

Responses

pgsql-sql by date

Next:From: Oliver JowettDate: 2004-04-19 22:21:02
Subject: Re: Prepared Statements and large where-id-in constant blocks?
Previous:From: scott.marloweDate: 2004-04-19 20:17:48
Subject: Re: [SQL] SQL script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group