Lisp HUG Maillist Archive

Problem with timestamps and Common SQL

Hi,

I'm currently learning how to use Common SQL on windows, and I'm having 
problems with dates and times.  If I modify a slot on a view class which 
contains a timestamp and try and write this modified instance back to 
the database with sql:update-records-from-instance, I get errors of the 
form :

Error: Sql-Database-Data-Error id HY000[7] : ERROR:  Bad timestamp 
external representation 'timestamp'2004-01-18 19:25:58''
   1 (abort) Return to level 0.
   2 Return to top loop level 0.

Type :b for backtrace, :c <option number> to proceed,  or :? for other 
options

I'm using LW 4.3.6 on Windows XP.

Barry.


Re: Problem with timestamps and Common SQL

Unable to parse email body. Email id is 1786

Re: Problem with timestamps and Common SQL

Unable to parse email body. Email id is 1787

Updated at: 2020-12-10 08:58 UTC