Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: external function
On Wed, 29 Dec 1999 19:21:19 GMT, maylee <mayleel_at_my-deja.com> wrote:
>Help!!
>
>I am creating a view the contains a column called "creation_date" from a
>main table.
>
>This date is the numeric representation of a UNIX date (on Solaris). I
>cannot find a "clean" way to conver this date to a date that is
>recognizable to oracle as being a valid date... I have thought of
>creating an external function in C that converts this date to an "ORACLE
>date" but is this the best way???
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Looks like this is unnecessary
how about
to_date(to_char(to_date('01-jan-70'),'J') + creation_date)
Hth,
Hth,
Sybrand Bakker, Oracle DBA Received on Wed Dec 29 1999 - 13:51:15 CST