Re: Simple Date Function

Use a DATE literal for the default.

"TT_STOP" DATE DEFAULT DATE '9999-11-30'

On Fri, May 24, 2013, at 10:24, risaldeep wrote:
>  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
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
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