diff options
| author | Bruce Momjian | 2005-05-27 21:31:23 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2005-05-27 21:31:23 +0000 |
| commit | d4b50caf25eeb6473fc3e19d35560f75700f7006 (patch) | |
| tree | bf8894eb5b4cfc10f4d718c11b93d1bab5fa8950 /src/test | |
| parent | 5dafb69e1723d6963288be31df2804738d1fc732 (diff) | |
Display only 9 subsecond digits instead of 10 for time values, for
consistency and to prevent rounding for days < 30. Also round off all
trailing zeros, rather than leaving an even number of digits.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/horology.out | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index ca8bc3d0e5c..c0a7f6e5b83 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -205,62 +205,62 @@ SET DateStyle = 'ISO'; -- As of 7.4, allow time without time zone having a time zone specified SELECT time without time zone '040506.789+08'; time ---------------- - 04:05:06.7890 +-------------- + 04:05:06.789 (1 row) SELECT time without time zone '040506.789-08'; time ---------------- - 04:05:06.7890 +-------------- + 04:05:06.789 (1 row) SELECT time without time zone 'T040506.789+08'; time ---------------- - 04:05:06.7890 +-------------- + 04:05:06.789 (1 row) SELECT time without time zone 'T040506.789-08'; time ---------------- - 04:05:06.7890 +-------------- + 04:05:06.789 (1 row) SELECT time with time zone '040506.789+08'; timetz ------------------- - 04:05:06.7890+08 +----------------- + 04:05:06.789+08 (1 row) SELECT time with time zone '040506.789-08'; timetz ------------------- - 04:05:06.7890-08 +----------------- + 04:05:06.789-08 (1 row) SELECT time with time zone 'T040506.789+08'; timetz ------------------- - 04:05:06.7890+08 +----------------- + 04:05:06.789+08 (1 row) SELECT time with time zone 'T040506.789-08'; timetz ------------------- - 04:05:06.7890-08 +----------------- + 04:05:06.789-08 (1 row) SELECT time with time zone 'T040506.789 +08'; timetz ------------------- - 04:05:06.7890+08 +----------------- + 04:05:06.789+08 (1 row) SELECT time with time zone 'T040506.789 -08'; timetz ------------------- - 04:05:06.7890-08 +----------------- + 04:05:06.789-08 (1 row) SET DateStyle = 'Postgres, MDY'; |