aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--src/backend/commands/variable.c2
-rw-r--r--src/backend/utils/adt/datetime.c2
-rw-r--r--src/test/regress/expected/date.out58
-rw-r--r--src/test/regress/expected/horology.out2
4 files changed, 32 insertions, 32 deletions
diff --git a/src/backend/commands/variable.c b/src/backend/commands/variable.c
index 27ce7d3f8fc..7df26942aff 100644
--- a/src/backend/commands/variable.c
+++ b/src/backend/commands/variable.c
@@ -182,7 +182,7 @@ check_datestyle(char **newval, void **extra, GucSource source)
if (!ok)
{
- GUC_check_errdetail("Conflicting \"datestyle\" specifications.");
+ GUC_check_errdetail("Conflicting \"DateStyle\" specifications.");
return false;
}
diff --git a/src/backend/utils/adt/datetime.c b/src/backend/utils/adt/datetime.c
index 7abdc62f41d..600b59190e4 100644
--- a/src/backend/utils/adt/datetime.c
+++ b/src/backend/utils/adt/datetime.c
@@ -4107,7 +4107,7 @@ DateTimeParseError(int dterr, DateTimeErrorExtra *extra,
(errcode(ERRCODE_DATETIME_FIELD_OVERFLOW),
errmsg("date/time field value out of range: \"%s\"",
str),
- errhint("Perhaps you need a different \"datestyle\" setting.")));
+ errhint("Perhaps you need a different \"DateStyle\" setting.")));
break;
case DTERR_INTERVAL_OVERFLOW:
errsave(escontext,
diff --git a/src/test/regress/expected/date.out b/src/test/regress/expected/date.out
index 20374c5230a..c9cec70c38d 100644
--- a/src/test/regress/expected/date.out
+++ b/src/test/regress/expected/date.out
@@ -94,17 +94,17 @@ SELECT date '1/8/1999';
ERROR: date/time field value out of range: "1/8/1999"
LINE 1: SELECT date '1/8/1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1/18/1999';
ERROR: date/time field value out of range: "1/18/1999"
LINE 1: SELECT date '1/18/1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '18/1/1999';
ERROR: date/time field value out of range: "18/1/1999"
LINE 1: SELECT date '18/1/1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01/02/03';
date
------------
@@ -139,7 +139,7 @@ SELECT date 'January 8, 99 BC';
ERROR: date/time field value out of range: "January 8, 99 BC"
LINE 1: SELECT date 'January 8, 99 BC';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '99-Jan-08';
date
------------
@@ -156,7 +156,7 @@ SELECT date '08-Jan-99';
ERROR: date/time field value out of range: "08-Jan-99"
LINE 1: SELECT date '08-Jan-99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '08-Jan-1999';
date
------------
@@ -167,7 +167,7 @@ SELECT date 'Jan-08-99';
ERROR: date/time field value out of range: "Jan-08-99"
LINE 1: SELECT date 'Jan-08-99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date 'Jan-08-1999';
date
------------
@@ -198,7 +198,7 @@ SELECT date '08 Jan 99';
ERROR: date/time field value out of range: "08 Jan 99"
LINE 1: SELECT date '08 Jan 99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '08 Jan 1999';
date
------------
@@ -209,7 +209,7 @@ SELECT date 'Jan 08 99';
ERROR: date/time field value out of range: "Jan 08 99"
LINE 1: SELECT date 'Jan 08 99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date 'Jan 08 1999';
date
------------
@@ -244,22 +244,22 @@ SELECT date '08-01-99';
ERROR: date/time field value out of range: "08-01-99"
LINE 1: SELECT date '08-01-99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '08-01-1999';
ERROR: date/time field value out of range: "08-01-1999"
LINE 1: SELECT date '08-01-1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01-08-99';
ERROR: date/time field value out of range: "01-08-99"
LINE 1: SELECT date '01-08-99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01-08-1999';
ERROR: date/time field value out of range: "01-08-1999"
LINE 1: SELECT date '01-08-1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '99-08-01';
date
------------
@@ -288,22 +288,22 @@ SELECT date '08 01 99';
ERROR: date/time field value out of range: "08 01 99"
LINE 1: SELECT date '08 01 99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '08 01 1999';
ERROR: date/time field value out of range: "08 01 1999"
LINE 1: SELECT date '08 01 1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01 08 99';
ERROR: date/time field value out of range: "01 08 99"
LINE 1: SELECT date '01 08 99';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01 08 1999';
ERROR: date/time field value out of range: "01 08 1999"
LINE 1: SELECT date '01 08 1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '99 08 01';
date
------------
@@ -345,7 +345,7 @@ SELECT date '1/18/1999';
ERROR: date/time field value out of range: "1/18/1999"
LINE 1: SELECT date '1/18/1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '18/1/1999';
date
------------
@@ -392,7 +392,7 @@ SELECT date '99-Jan-08';
ERROR: date/time field value out of range: "99-Jan-08"
LINE 1: SELECT date '99-Jan-08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-Jan-08';
date
------------
@@ -435,7 +435,7 @@ SELECT date '99 Jan 08';
ERROR: date/time field value out of range: "99 Jan 08"
LINE 1: SELECT date '99 Jan 08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999 Jan 08';
date
------------
@@ -480,7 +480,7 @@ SELECT date '99-01-08';
ERROR: date/time field value out of range: "99-01-08"
LINE 1: SELECT date '99-01-08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-01-08';
date
------------
@@ -515,7 +515,7 @@ SELECT date '99-08-01';
ERROR: date/time field value out of range: "99-08-01"
LINE 1: SELECT date '99-08-01';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-08-01';
date
------------
@@ -526,7 +526,7 @@ SELECT date '99 01 08';
ERROR: date/time field value out of range: "99 01 08"
LINE 1: SELECT date '99 01 08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999 01 08';
date
------------
@@ -561,7 +561,7 @@ SELECT date '99 08 01';
ERROR: date/time field value out of range: "99 08 01"
LINE 1: SELECT date '99 08 01';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999 08 01';
date
------------
@@ -603,7 +603,7 @@ SELECT date '18/1/1999';
ERROR: date/time field value out of range: "18/1/1999"
LINE 1: SELECT date '18/1/1999';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '01/02/03';
date
------------
@@ -644,7 +644,7 @@ SELECT date '99-Jan-08';
ERROR: date/time field value out of range: "99-Jan-08"
LINE 1: SELECT date '99-Jan-08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-Jan-08';
date
------------
@@ -731,7 +731,7 @@ SELECT date '99-01-08';
ERROR: date/time field value out of range: "99-01-08"
LINE 1: SELECT date '99-01-08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-01-08';
date
------------
@@ -766,7 +766,7 @@ SELECT date '99-08-01';
ERROR: date/time field value out of range: "99-08-01"
LINE 1: SELECT date '99-08-01';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999-08-01';
date
------------
@@ -777,7 +777,7 @@ SELECT date '99 01 08';
ERROR: date/time field value out of range: "99 01 08"
LINE 1: SELECT date '99 01 08';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999 01 08';
date
------------
@@ -812,7 +812,7 @@ SELECT date '99 08 01';
ERROR: date/time field value out of range: "99 08 01"
LINE 1: SELECT date '99 08 01';
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
SELECT date '1999 08 01';
date
------------
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out
index 82c0e1a12f2..6d7dd5c988f 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -105,7 +105,7 @@ SELECT timestamp with time zone '27/12/2001 04:05:06.789-08';
ERROR: date/time field value out of range: "27/12/2001 04:05:06.789-08"
LINE 1: SELECT timestamp with time zone '27/12/2001 04:05:06.789-08'...
^
-HINT: Perhaps you need a different "datestyle" setting.
+HINT: Perhaps you need a different "DateStyle" setting.
set datestyle to dmy;
SELECT timestamp with time zone '27/12/2001 04:05:06.789-08';
timestamptz
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-21 23:00:29 +0000