diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-17 00:55:37 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-17 00:55:37 +0000 |
| commit | 764f72dc823edb3f8bdf387501ce4c12dedd2369 (patch) | |
| tree | 01838a17f094eb1ac2a0f99102002adbff063605 /src/backend/utils/adt/nabstime.c | |
| parent | 93236b58e088cd2151540528d484da9ad82e48c8 (diff) | |
| download | postgresql-764f72dc823edb3f8bdf387501ce4c12dedd2369.tar.gz postgresql-764f72dc823edb3f8bdf387501ce4c12dedd2369.zip | |
Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention
for the sign of timezone offsets, ie, positive is east from UTC. These
were previously out of step with other operations that accept or show
timezones, such as I/O of timestamptz values.
Diffstat (limited to 'src/backend/utils/adt/nabstime.c')
| -rw-r--r-- | src/backend/utils/adt/nabstime.c | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/src/backend/utils/adt/nabstime.c b/src/backend/utils/adt/nabstime.c index fe14c9bec4f..88943a76676 100644 --- a/src/backend/utils/adt/nabstime.c +++ b/src/backend/utils/adt/nabstime.c @@ -10,7 +10,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/nabstime.c,v 1.108 2003/05/12 23:08:50 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/nabstime.c,v 1.109 2003/07/17 00:55:37 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -825,12 +825,14 @@ reltimesend(PG_FUNCTION_ARGS) static void reltime2tm(RelativeTime time, struct tm * tm) { - TMODULO(time, tm->tm_year, 31557600); - TMODULO(time, tm->tm_mon, 2592000); - TMODULO(time, tm->tm_mday, 86400); - TMODULO(time, tm->tm_hour, 3600); - TMODULO(time, tm->tm_min, 60); - TMODULO(time, tm->tm_sec, 1); + double dtime = time; + + FMODULO(dtime, tm->tm_year, 31557600); + FMODULO(dtime, tm->tm_mon, 2592000); + FMODULO(dtime, tm->tm_mday, 86400); + FMODULO(dtime, tm->tm_hour, 3600); + FMODULO(dtime, tm->tm_min, 60); + FMODULO(dtime, tm->tm_sec, 1); } |