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

Home -> Community -> Mailing Lists -> Oracle-L -> set time ??

set time ??

From: KH Lim <eric_sato_at_yahoo.com>
Date: Tue, 5 Sep 2000 00:08:49 -0700 (PDT)
Message-Id: <10610.116182@fatcity.com>


Dear all,
i'm a new subsriber and newt to oracle here. please help me out with this question.
how to set time in date datatype
for example,

Date_datatype



12-12-2000 12:12:00
01-23-2000 15:19:00
.
.
.
.

and i want the result as

Date_datatype



12-12-2000 07:48:00
01-23-2000 07:48:00
.
.
.
.
.

all are with remain date but time is set to 07:48:00 thanks in advance
from kh Lim



Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Tue Sep 05 2000 - 02:08:49 CDT

Original text of this message

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