Re: will this date formatting work?

Jim Kennedy wrote:

>Different DBMS deal with date FORMATS differently. Live with it; it is a
>fact. By trying to be "database independent" you are going to shoot
>yourself in the foot big time.
>You should be able to do:
>CREATE TABLE STP_SystemDate (
> SystemDate date default sysdate NOT NULL
> );
>
>
><snipped>
>

The only way to be database independent is to use 3x5 cards. ;-)

But the one way to successfully emulate that is to create your own application based
standard and then for each database vendor's produt build a meta layer that turns everything
from the vendor's product into your own application specific calls.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)