On Tuesday, 15 October 2013 at 04:41:13 UTC, Kagamin wrote:
On Monday, 14 October 2013 at 21:18:32 UTC, Walter Bright wrote:
Yah, that is terribly confusing, especially considering the
global intarnets.
I get bitten by it locally too: if there's a test with an
inaccurate sql query with time formatted as string, the sql
server doesn't always compute it, because the default
"human-readable" time format is taken from the current locale,
and to parse it one first has to guess the format itself, which
is quite difficult in a heterogeneous system.
This is for that very reason that I prefers to work with
timestamps UTC as much as possible. No timzone hell, no format
hell, no nothing. Just convert from user input directly, and
convert back to text just before output.