bill-lancaster said

A date-time value  is converted from British Summer Time to UTC when writing a mysql record.

Code

  hResult = hConn.create("date_test")
  hResult!DateTimeCreated = Now
  hResult!DateTimeEvent = Date(2021, 4, 16, 9, 35, 00)


The resulting time values in the mysql db are 1 hour less.

This is probably a mysql matter but I wonder if anyone can help?

bill-lancaster said

Thanks Bruce, still confused though!
In gambas print date(), time() all show the right value.
My system clock is correct
Mysql locale is shown as "System"
I'm thinking its really an sql matter

wiki said

Dates are not strings
The confusion mainly comes from the fact that you are thinking about dates by using its locale string representation, i.e. as if the Date datatype would represent a locale date. Big mistake!

Internally, Gambas stores a Date value in Universal Time (a.k.a. "UTC"), using two 32 bits integer:

    The first integer is a number of days since a specific epoch, which is January 1st, 4801 BC. It's the date part.

    The second integer is a number of milliseconds since midnight. It's the time part.

But there is no way in Gambas to directly write a Date constant. You always has to use either the Date function that builds a date or convert a string representation of the date by using CStr, CDate, Str$ or Val.

Consequently, each time you manipulate a date representation, Gambas has to decide if your date representation is in U.T.C. or in local time. In other words, the timezone associated with a date representation is implicit.

bill-lancaster said

Either the value is adjusted before writing to the db or the adjustment is made when reading the db.
I favour the latter, CDATE() displays the correct (local) time value.
Thanks again.

bill-lancaster said

Time(mysql!DateTime) also shows British Summer Time