Re: Date function that leaves only the time?

From: Norman Dunbar <norman.dunbar_at_lfs.co.uk>
Date: 17 Dec 2003 10:37:41 -0800
Message-ID: <3078e2fe.0312171037.52a61ea0@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1070914016.474622_at_yasure>...

> This brings up an interesting question. If I perform the following
> query:
>
> SQL> select argument_name, data_type
> 2 from all_arguments
> 3 where object_name = 'TO_TIME';
>

<SNIP>
>
> I get something that seems to be undocumented at tahiti.oracle.com.
>
> Does anyone have an example of using this?
>
> Thanks.

Daniel,

it seems to be part of SYS.STANDARD and turns up if you desc sys.standard. However, calling it results in the following, even if connected as SYS :

SQL> select sys.standard.to_time(sysdate) from dual; select sys.standard.to_time(sysdate) from dual

           *
ERROR at line 1:
ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-302: component 'TO_TIME' must be declared

SQL> select sys.standard.to_char(sysdate) from dual;

SYS.STANDARD.TO_CHAR(SYSDATE)

---

17-DEC-03 Still, it looks interesting ........

On the other hand, maybe it is an internal use only helper function for the TO_TIMEZONE function ?

Cheers,
Norm. Received on Wed Dec 17 2003 - 12:37:41 CST