id	summary	reporter	owner	description	type	status	milestone	component	version	severity	resolution	keywords	cc
4029	_Date_Time_SystemTimeToDateTimeStr() wrong output	jchd18	Jpm	"The function _Date_Time_SystemTimeToDateTimeStr() has two related but distinct bugs.

Note: the timestamp returned by _Date_Time_GetSystemTime() is raw UTC.

{{{
Local $tST = _Date_Time_GetSystemTime()
ConsoleWrite(_Date_Time_SystemTimeToDateTimeStr($tST, 1, 0) & @LF)
ConsoleWrite(_Date_Time_SystemTimeToDateTimeStr($tST, 1, 1) & @LF)
}}}
produces the same output:
{{{
2024/09/26 12:23:46
2024/09/26 12:23:46
}}}
but the first should be shifted by timezone and DST settings. (I'm in France and currently UTC+02:00.)

{{{
Local $tST = _Date_Time_GetSystemTime()
ConsoleWrite(_Date_Time_SystemTimeToDateTimeStr($tST, 3, 0) & @LF)
ConsoleWrite(_Date_Time_SystemTimeToDateTimeStr($tST, 3, 1) & @LF)
}}}
produces a very wrong output:
{{{
2024-09-26T12:30:29-02:00
2024-09-26T12:30:29Z
}}}
The second output correctly displays the UTC time.
The first line has YMDhms wrong by 2 hours and timeshift should read ""+02:00"", hence the first line should be showing local time with offset from UTC, like this:
{{{
2024-09-26T14:30:29+02:00
}}}
The above reads ""it's 14:30:29 local time, and offset from UTC is +2h"". To compute UTC from that, one must subtract the offset from the timestamp.

The help file is ambiguous and even wrong on the role of parameter $iType.
"	Bug	closed	3.3.17.0	Standard UDFs	3.3.14.0	None	Fixed