Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> help needed in data datatype

help needed in data datatype

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Tue, 03 Jul 2001 13:06:48 -0700
Message-ID: <F001.00340A7E.20010703131318@fatcity.com>

Hi,
I have a table with colum defined as date<SPAN class=671200920-03072001><FONT color=#000000 face="Times New Roman"> datatype ..for
example
create table dd(dd date);
when we insert into this table like :
insert into dd values('04-jul-01');
when we do select as:
select to_char(dd,'DD-MON-YYYY HH24:MI:SS') from dd; the result displayed is :
TO_CHAR(DD,'DD-MON-Y



04-JUL-2002 00:00:00
our application requires time to store as 23:59:59 and not as 00:00:00(midnight)....
How can i make a check or apply some rule that whenever someone inserts into
this column time always added as 23:59:59........ Thanks
Harvinder Received on Tue Jul 03 2001 - 15:06:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US