Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory 
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8181/src/test/BugTracker-2008/Tests

Added Files:
      Tag: SQL_2-24
        extract_bug.SF-2075266.sql 
Log Message:
more tests


--- NEW FILE: extract_bug.SF-2075266.sql ---

CREATE TABLE A (FIPS2 TIMESTAMP);

INSERT INTO A VALUES (
TIMESTAMP '1996-08-24 16:03:00.999999');

SELECT EXTRACT (SECOND FROM FIPS2)
* 1000000 - 999990 FROM A;

select EXTRACT (SECOND FROM FIPS2) FROM A;

drop table A;


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to