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
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to