| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: set time ??
Something like this:
SQL> alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
Session altered.
SQL> select to_date(to_char(sysdate,'dd-mm-yyyy') || ' ' || '07:48:00','dd-mm-yyyy hh24:mi:ss')
from dual;
TO_DATE(TO_CHAR(SYS
Where sysdate is the date_field.
HTH
Jorma
> -----Original Message-----
> From: EXT KH Lim [mailto:eric_sato_at_yahoo.com]
> Sent: 05. September 2000 11: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:02:12 CDT
 |
 |