Re: Need help Datefield Retrieval like this mmddyyyy

["Steven E. Davies" <sedavies@YAHOO.COM>]

(Note: Sorry about the delay. I tried getting this to the list earlier
but there is some problems when forwarding messages to the list. Can't
refer to the mailing list in the forwarded message.)

Peter,

First, when you make a correction like this, it would be best to send
it out to the entire list. I appreciate your diplomacy but we
shouldn't let people go down the wrong path. :-)

Secondly, I was wondering how fast this would be caught. Good job,
Peter. TO_CHAR is standard only to Oracle. If you're writing for
other platforms this should be kept in mind.

I'm sorry folks. I have a bit of the devil's advocate in me. But, some
people say I have something else in me too.

Sorry for the deception. :-)

Steve

---Peter Alan Burton <peterb@sqribe.com> wrote:
>
> Steven,
>
> The TO_CHAR() function does not exist in DB2, Informix,
Sybase,Ingres,
> ODBC, SQLBase, Redbrick Warehouse.
>
> I cannot believe that all the above databases do not follow the SQL
> standard.
>
> From what source does it state that the TO_CHAR() function as
implemented
> by ORACLE meet the ANSI SQL standard definition.>
> Peter




==


Steven E. Davies
------------------------------
"Quid quid latine dictum sit,
 altum viditur."
------------------------------
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com