Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: function NOW() to return sysdate
RTM. You should think of dates as dates and not strings. What you are
doing is worrying about how the date is formatted as a string and it really
should be treated as a date. The docs are online at otn.oracle.com
Jim
"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 - 09:12:29 CST