diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-23 14:25:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-23 14:25:34 +0000 |
| commit | 3dbbbbf8e98329e1eea9920436defc64af3594d3 (patch) | |
| tree | 38d2b294496f12135a7b01e6d3da99912d72b5bf /src/backend/utils/adt/formatting.c | |
| parent | 6c61b0d93cd5378bfb64959b9e738fe02413cefe (diff) | |
| download | postgresql-3dbbbbf8e98329e1eea9920436defc64af3594d3.tar.gz postgresql-3dbbbbf8e98329e1eea9920436defc64af3594d3.zip | |
Andrew pointed out that the current fix didn't handle dates that were
near daylight savings time boudaries. This handles it properly, e.g.
test=> select '2005-04-03 04:00:00'::timestamp at time zone
'America/Los_Angeles';
timezone
------------------------
2005-04-03 07:00:00-04
(1 row)
Diffstat (limited to 'src/backend/utils/adt/formatting.c')
| -rw-r--r-- | src/backend/utils/adt/formatting.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/adt/formatting.c b/src/backend/utils/adt/formatting.c index 9f1cc1a4768..b473b9b13b4 100644 --- a/src/backend/utils/adt/formatting.c +++ b/src/backend/utils/adt/formatting.c @@ -1,7 +1,7 @@ /* ----------------------------------------------------------------------- * formatting.c * - * $PostgreSQL: pgsql/src/backend/utils/adt/formatting.c,v 1.92 2005/07/21 03:56:16 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/formatting.c,v 1.93 2005/07/23 14:25:33 momjian Exp $ * * * Portions Copyright (c) 1999-2005, PostgreSQL Global Development Group @@ -2989,7 +2989,7 @@ to_timestamp(PG_FUNCTION_ARGS) do_to_timestamp(date_txt, fmt, &tm, &fsec); - tz = DetermineLocalTimeZone(&tm); + tz = DetermineTimeZoneOffset(&tm, global_timezone); if (tm2timestamp(&tm, fsec, &tz, &result) != 0) ereport(ERROR, |