[Gambas-bugtracker] Bug #1448: Date is not correct when you read mysql database

[bugtracker at gambaswiki.org]

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

Comment #1 by Benoît MINISINI:

No, the result is correct.

First, as MySQL tells nothing of the timezone of the field, it is assumed to be in localtime (which is a problem as soon as your database is accessed all around the world, but let's ignore that).

Next, by concatenating a string and a date with the '&' operator, you force Gambas to convert the date to a string with the CStr() instruction, which always returned the UTC date.

Hence the date is displayed UTC, not in your timezone.

Benoît MINISINI changed the state of the bug to: Rejected.