Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Date datatype
Hi
>According to the FM, the function doesn't work with
>date field,=20
You are right. Unfortunately 1) I didn't get my memory upgrade yet 2) I = use TIMESTAMP most of the time, therefore I didn't get this error...
>only with timestamp with time zone data type:
Be careful, with a "simple" TIMESTAMP it works as well...
SQL> create table t1 (d date, tz timestamp);
SQL> insert into t1 values (sysdate, sysdate);
SQL> select extract(minute from tz) from t1;
EXTRACT(MINUTEFROMTZ)
38>> field to a date column and it worked for the
>> 3.. I tried to add a numeric value from another
I will never show you how to add 1/24 to a date... otherwise we will = never learn to learn! Instead I give you another hint: the arithmetic = operator to add two values is the character plus, i.e. "+".
HTH
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 05 2005 - 13:48:23 CDT