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

Home -> Community -> Usenet -> c.d.o.server -> Re: function NOW() to return sysdate

Re: function NOW() to return sysdate

From: mcstock <mcstock_at_enquery.com>
Date: Wed, 29 Oct 2003 08:02:33 -0500
Message-ID: <5sSdnbehqLIRJwKiRVn-hQ@comcast.com>


create a function that users TO_CHAR and SYSDATE

create public synonym for the function

grant execute on the function to public

refer to the SQL Reference for details on these commands and functions

-- CREATE FUNCTION
-- CREATE SYNONYM
-- GRANT
-- TO_CHAR
-- SYSDATE

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048

"Neil Zanella" <nzanella_at_cs.mun.ca> wrote in message
news:Pine.LNX.4.44.0310290508540.14042-100000_at_garfield.cs.mun.ca...

>
> Hello,
>
> I would like to write an Oracle function called NOW() for compatibility
> with PostgreSQL. I would like such a function to simply return sysdate.
> I would also like to set the date format to standard Unix 'date -I' AKA
> ISO 8601 format. Anyone know how these portability tasks could be
> accomplished?
>
> Thanks,
>
> Neil
>
Received on Wed Oct 29 2003 - 07:02:33 CST

Original text of this message

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