Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: function NOW() to return sysdate
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...Received on Wed Oct 29 2003 - 07:02:33 CST
>
> 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
>