🚀 go-pugleaf

I have a JBuilder 2.0 application that reads DateTime fields from a
Sybase Database.  The data is resolved back to the database using the
post and save buttons on the Navigator Control bar.  However, when I
click on the save button, I get the following error message:

[INTERSOLV][ODBC SQL Server driver][SQL Server] Syntax error during
implicit conversion of CHAR value '1998-11-25 00:00:00.000000000' to a
DATETIME field.

The datetime column is read into JBuilder as a TIMESTAMP datatype.

Does anyone know what is going on here, and if so is there a way to fix
this problem?  The editmask and displaymask on the column are set to
M/d/yy, but somehow during the update, the columns that are assigned as
timestamp values are converted to this obscure format, which is too long

to work with the update command.  I have tried changing the precision of

the column among many other things but nothing works.  I get this same
error message if I enter the SQL update command manually with the same
date format.  However, if I reduce the date format to 23 characters
instead of 29 it works fine.  Sybase sets a limit of 23 characters on
DATETIME fields, so the TIMESTAMP value assigned by JBuilder is too
long.

Any help would be greatly appreciated.

Thanks,

--
Dawn Snow

CCIT
Medical University of South Carolina
Phone: 843-792-5470
Fax: 843-792-8319
email: snowrd@musc.edu