From 764122471a85ac37cc11eb4d944102c5c39afe71 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 14 Feb 2007 05:10:55 +0000 Subject: [PATCH] Fix to_date()/to_timestamp() 'D' field for day of week, was off by one. Converting from char using 'D' doesn't make lots of sense, of course. Report from Brendan Jurd. --- src/backend/utils/adt/formatting.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/backend/utils/adt/formatting.c b/src/backend/utils/adt/formatting.c index 74e2db6082..80de2f20e4 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.123 2007/02/13 02:00:55 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/formatting.c,v 1.124 2007/02/14 05:10:55 momjian Exp $ * * * Portions Copyright (c) 1999-2007, PostgreSQL Global Development Group @@ -2484,6 +2484,7 @@ dch_date(int arg, char *inout, int suf, bool is_to_char, bool is_interval, else { sscanf(inout, "%1d", &tmfc->d); + tmfc->d--; return strspace_len(inout) + 1 + SKIP_THth(suf); } break; -- 2.40.0