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

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

RE: set time ??

From: <ddorr.cs_at_clearstream.com>
Date: Tue, 5 Sep 2000 10:20:20 +0200
Message-Id: <10610.116185@fatcity.com>


Something like :

to_date(to_char(<your date here>,'DD-MM-YYYY') || ' 07:48:00','DD-MM-YYYY HH24:MI:SS')

should do it.

> ----------
> From: KH Lim[SMTP:eric_sato_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, September 05, 2000 10:11
> To: Multiple recipients of list ORACLE-L
> Subject: set time ??
>
> 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!
> http://mail.yahoo.com/
> --
> Author: KH Lim
> INET: eric_sato_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Sep 05 2000 - 03:20:20 CDT

Original text of this message

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