diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-29 00:03:19 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-29 00:03:19 +0000 |
| commit | 9c2a7c2269d1ecebd7f83e769bb2640cb82fa0e0 (patch) | |
| tree | f868b45501a84e01215cefb03754bab63e23730b /src/test/regress/sql/timestamptz.sql | |
| parent | 2baf4efe09f65d8e8cac32fb882ab9f0fd601574 (diff) | |
| download | postgresql-9c2a7c2269d1ecebd7f83e769bb2640cb82fa0e0.tar.gz | |
Apply (a somewhat revised version of) Greg Mullane's patch to eliminate
heuristic determination of day vs month in date/time input. Add the
ability to specify that input is interpreted as yy-mm-dd order (which
formerly worked, but only for yy greater than 31). DateStyle's input
component now has the preferred spellings DMY, MDY, or YMD; the older
keywords European and US are now aliases for the first two of these.
Per recent discussions on pgsql-general.
Diffstat (limited to 'src/test/regress/sql/timestamptz.sql')
| -rw-r--r-- | src/test/regress/sql/timestamptz.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/test/regress/sql/timestamptz.sql b/src/test/regress/sql/timestamptz.sql index e60bacb962..71414f198e 100644 --- a/src/test/regress/sql/timestamptz.sql +++ b/src/test/regress/sql/timestamptz.sql @@ -74,9 +74,11 @@ INSERT INTO TIMESTAMPTZ_TBL VALUES ('1997-02-10 17:32:01 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb-10-1997 17:32:01 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('02-10-1997 17:32:01 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('19970210 173201 PST'); +set datestyle to ymd; INSERT INTO TIMESTAMPTZ_TBL VALUES ('97FEB10 5:32:01PM UTC'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('97/02/10 17:32:01 UTC'); -INSERT INTO TIMESTAMPTZ_TBL VALUES ('97.041 17:32:01 UTC'); +reset datestyle; +INSERT INTO TIMESTAMPTZ_TBL VALUES ('1997.041 17:32:01 UTC'); -- Check date conversion and date arithmetic INSERT INTO TIMESTAMPTZ_TBL VALUES ('1997-06-10 18:32:01 PDT'); |