[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
new database component problem
[Thread Prev] | [Thread Next]
- Subject: new database component problem
- From: BB <adamnt42@xxxxxxxxx>
- Date: Sun, 25 Aug 2024 16:45:18 +0930
- To: Gambas Mailing List <user@xxxxxxxxxxxxxxxxxxxxxx>
When using the gb.db2 with a postgres database I came across a problem with date columns.
Setting the result column to a date, for example
Dim myDate as Date=Date("2024","8","1")
rlt!startdate = mydate
seems to work OK until the result is saved, which fails with an error
and the date field has an aberrant "." on the end. IOW the date field in
the update is "2024-08-01 00:00:00."
It occurs at [gb.db2.postgresql]._DatabaseDriver_Postgresql.Query.134 b
| Re: new database component problem | Benoît Minisini <benoit.minisini@xxxxxxxxxxxxxxxx> |