[Gambas-bugtracker] Bug #3048: gb.db2 Type mismatch: wanted Date, got String instead.

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3048&from=L21haW4-

Comment #3 by Benoît MINISINI:

Sorry, but your English is not fully correct, so I don't understand what you are talking about.

The bug report is not clear either. But Bruce's answer is correct: if you want to put a date or a date/time value in a field, you have
to use the Gambas 'Date' datatype.

But the target database field must match: if it's only a 'DATE' SQL field, it will never store the time part.

And if you store a date with a time, as returned by 'Now', you can't expect to have only a date in the database as soon as the field is a SQL 'DATETIME'.


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----