RE: new Timestamp(Long.MAX_VALUE) as jdbc arg causes error

Hi,
you are trying to insert the timestamp "292278994-08-17 07:12:55.807". Maybe SAP DB supports such large timestamps in the year 9999;) But currently the maximum possible timestamp value that can be handled by SAP DB is "9999-12-31 23:59:59.999". So I would like to recommend to use this value instead of Long.MAX_VALUE.  

Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Max [mailto:[email protected]]
> Sent: Dienstag, 26. August 2003 19:09
> To: [email protected]
> Subject: new Timestamp(Long.MAX_VALUE) as jdbc arg causes error
> 
> 
> 
>    I need to set a timestamp field to an
> 
>   "end of time" date/time
> 
> ...
>    preparedStatement.set(x, new Timestamp(Long.MAX_VALUE));
> 
> 
>   I get an exception that says invalid ISO date format ...
> 
> 
>   I just need to represent a date that will be greater or equal to
> any Java dates.
> 
> 
>   Should I use another (smaller?) constant, if yes
> what is it ?
> 
>   Or is this a bug that will be fixed ?
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>