diff options
| author | Bruce Momjian <bruce@momjian.us> | 2015-04-28 21:02:57 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2015-04-28 21:02:57 -0400 |
| commit | 9b43d73b3f9bef276a46660920a01f0421c4323a (patch) | |
| tree | 199f75ff9ac5faf17faa577fe82e6b201b6e10a5 /src/backend/utils/adt/formatting.c | |
| parent | 5086dfceba79ecd5d1eb28b8f4ed5221838ff3a6 (diff) | |
| download | postgresql-9b43d73b3f9bef276a46660920a01f0421c4323a.tar.gz postgresql-9b43d73b3f9bef276a46660920a01f0421c4323a.zip | |
to_char(): have format 'OF' only show the leading negative sign
Previously both hours and minutes displayed as negative.
Report by David Pozsar
Diffstat (limited to 'src/backend/utils/adt/formatting.c')
| -rw-r--r-- | src/backend/utils/adt/formatting.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/adt/formatting.c b/src/backend/utils/adt/formatting.c index 40a353f5134..576db95c1be 100644 --- a/src/backend/utils/adt/formatting.c +++ b/src/backend/utils/adt/formatting.c @@ -2507,7 +2507,7 @@ DCH_to_char(FormatNode *node, bool is_interval, TmToChar *in, char *out, Oid col s += strlen(s); if (tm->tm_gmtoff % SECS_PER_HOUR != 0) { - sprintf(s, ":%02ld", (tm->tm_gmtoff % SECS_PER_HOUR) / SECS_PER_MINUTE); + sprintf(s, ":%02ld", abs(tm->tm_gmtoff % SECS_PER_HOUR) / SECS_PER_MINUTE); s += strlen(s); } break; |