Re: Simple Date Function

 I 'm using this script to create table tx_in_transit ..
-------------------------------  
CREATE TABLE RTN_TEST.TX_IN_TRANSIT ("ID" BIGINT,
"PATIENT_NUM" VARCHAR(100),
"CLAIM_NUM" VARCHAR(100),
"CLAIM_SEQ_NUM" VARCHAR(40),
"FIRING_CONTEXT_NUM" VARCHAR(40),
"PROVIDER_NUM" VARCHAR(100),
"TX_REQUEST_REF" BIGINT,
"CORRELATOR_ID" BIGINT,
"ROUTE" VARCHAR(500),
"INTERCHANGE" LONGVARBINARY,
"TT_START"  TIMESTAMP DEFAULT SYSDATE,
"TT_STOP" DATE DEFAULT TO_DATE( '30/11/9999', 'DD/MM/YYYY')
)
-------------------------------------------
and i got this error..
Caused by: org.hsqldb.HsqlException: unexpected token: TO_DATE : line: 12778
	at org.hsqldb.error.Error.parseError(Unknown Source)
	at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
	at org.hsqldb.ParserRoutine.readDefaultClause(Unknown Source)
	at org.hsqldb.ParserDDL.readColumnDefinitionOrNull(Unknown Source)
	at org.hsqldb.ParserDDL.compileCreateTableBody(Unknown Source)
	at org.hsqldb.ParserDDL.compileCreateTable(Unknown Source)
.....


Any suggestion Plzzzz!!!!!!



--
View this message in context: http://hsqldb.10974.n7.nabble.com/Simple-Date-Function-tp852p3891.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may