db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <be...@sun.com>
Subject Derby and SQL standard compliance
Date Mon, 07 Mar 2005 09:53:26 GMT
Is there any documentation which maps Derby features to one of the
SQL-standards (e.q. the SQL-99 feature list)? 

It seems to me that there are some deviations like e.g.
Derby has a DATE bultin function defined like this:
      DATE ( expression )
while SQL-99 (and 92) has a DATE literal defined like this
      DATE <date string>

(Likewise with TIME and TIMESTAMP).
-- 
Bernt Marius Johnsen, HA Data Management, Sun Microsystems, Norway
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE: This signature is neither personal, religious, literary,
ethnic, racial, offensive nor humorous. 

Mime
View raw message