Date and Datetime format in TWebClientDataset.GetPendingUpdates

[wlandgraf (Wagner Landgraf)]

Now it's clear

Try to use this approach:

TMS Xdata - ISO 8601 and UTC

You can enable support for the Z suffix this way: uses Bcl.Utils; ... DefaultTimeZoneMode := TTimeZoneMode.AsLocal; Note this will not only access the Z but will also convert the date to local time. If you want the parser to just access the Z suffix but ignore it as an UTC date, considering it just a local date, use Ignore: DefaultTimeZoneMode := TTimeZoneMode.Ignore;

and here is a more detailed explanation about the options:

Date format issues with MariaDb

By default, ISOToDateTime doesn't accept time zones. There is an overload method that you can pass the TTimeZoneMode, which you specify how time zone must be treated: class function ISOToDateTime(const Value: string; TimeZoneMode: TTimeZoneMode): TDateTime; overload; TTimeZoneMode = (Error, Ignore, AsUTC, AsLocal); Default is Error, which means if the date has timezone information, a error will be raised. You can use any of the other options: Ignore will simply strip out the time zone and ig…