RE: Sql Oddity

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: "'Richard.Goulet@xxxxxxxxxxx'" <Richard.Goulet@xxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 18 Jan 2010 12:36:11 -0800


I get 1 in and

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P  Please consider the environment before printing this e-mail

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Goulet, Richard
Sent: Monday, January 18, 2010 12:26 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Sql Oddity


        Anyone ever seen this:  A developer executes the following code in an 
Oracle 9i database (

create table test_date_drop_me (test_column timestamp default sysdate);

insert into test_date_drop_me values (sysdate);

select CASE WHEN systimestamp> t.test_column THEN 1 ELSE 0 END from 
test_date_drop_me t;

He gets a 0 each time the final select statement is excecuted no matter what 
the value in the table.  In a and database we get a 1.  Any 

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
900 Chelmsford St, Suite 310
Lowell, MA 01821

The information transmitted in this communication is intended only for the 
person or entity to which it is addressed and may contain confidential and/or 
privileged material. Any review, retransmission, dissemination or other use of, 
or taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited. If you received this 
in error, please destroy any copies, contact the sender and delete the material 
from any computer.

Other related posts: