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 -> function NOW() to return sysdate

function NOW() to return sysdate

From: Neil Zanella <nzanella_at_cs.mun.ca>
Date: Wed, 29 Oct 2003 05:10:56 -0330
Message-ID: <Pine.LNX.4.44.0310290508540.14042-100000@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 - 02:40:56 CST

Original text of this message

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