query.cc: $date returns time in GMT only

[sage]

The $date function uses gmtime() instead localtime() for converting time into tm structure. It is not possible to get time according locale system settings.

[olly]

localtime() isn't really the correct answer either - the timezone the server is in is usually an "implementation detail". On an intranet it will probably work OK (unless your intranet spans multiple timezones), but not for a website on the internet.

But there certainly is an issue here - UTC is an arbitrary choice.

Ideally we'd determine the timezone of the end-user automatically and use that, but it's not trivial to find - it requires some javascript magic, and a mechanism to get the information back to the server.

Perhaps in the short term, localtime() is better than gmtime() since at least it works better for most intranet cases.