RE: help needed in data datatype

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Tue, 03 Jul 2001 13:22:53 -0700
Message-ID: <F001.00340AF2.20010703133609@fatcity.com>

Harvinder, insert it with the time.  See below.  Try your example with sysdate and you'll see what I mean.

16:33:03 (CRS.WORLD-CRS)>create table lisa (datetest date);

Table created.

16:33:10 (CRS.WORLD-CRS)>insert into lisa values (sysdate);

1 row created.

16:33:17 (CRS.WORLD-CRS)>/ 1 row created.

16:33:18 (CRS.WORLD-CRS)>/ 1 row created.

16:33:20 (CRS.WORLD-CRS)>insert into lisa values ('16-jun-01');

1 row created.

16:33:31 (CRS.WORLD-CRS)>commit;

Commit complete.

16:33:32 (CRS.WORLD-CRS)>select to_char(datetest,'dd-mon-yyyy hh24:Mi:ss') from lisa;

TO_CHAR(DATETEST,'DD-MON-YYYYHH24:MI:SS')

---

03-jul-2001 16:33:20
03-jul-2001 16:33:21
03-jul-2001 16:33:22
16-jun-2001 00:00:00

16:33:45 (CRS.WORLD-CRS)>
-----Original Message-----

From:   Harvinder Singh [SMTP:Harvinder.Singh_at_MetraTech.com]
Sent:   Tuesday, July 03, 2001 5:13 PM
To:     Multiple recipients of list ORACLE-L

Subject:        help needed in data datatype

Hi,

I have a table with colum defined as date 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:22:53 CDT