summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/time.sql
Commit message (Collapse)AuthorAgeFilesLines
* Allow a time zone to be specified (and silently ignored) in the inputTom Lane2003-01-311-4/+3
| | | | | | | for type 'time without time zone', as we already did for type 'timestamp without time zone'. This patch was proposed by Tom Lockhart on 7-Nov-02, but he never got around to applying it. Adjust regression tests and documentation to match.
* Implement precision support for timestamp and time, both with and withoutThomas G. Lockhart2001-10-031-1/+1
| | | | | | | | | | | | time zones. SQL99 spec requires a default of zero (round to seconds) which is set in gram.y as typmod is set in the parse tree. We *could* change to a default of either 6 (for internal compatibility with previous versions) or 2 (for external compatibility with previous versions). Evaluate entries in pg_proc wrt the iscachable attribute for timestamp and other date/time types. Try to recognize cases where side effects like the current time zone setting may have an effect on results to decide whether something is cachable or not.
* Add separate regression tests for timetz and the new timestamptz type.Thomas G. Lockhart2001-09-281-12/+12
| | | | | Modify the timestamp test to reflect the "no time zone" behavior of this new code; timestamptz resembles the old timestamp code.
* Repair usage of the OVERLAPS operator.Thomas G. Lockhart2000-12-031-38/+7
| | | | | | | | Allow some operator-like tokens to be used as function names. Flesh out support for time, timetz, and interval operators and interactions. Regression tests pass, but non-reference-platform horology test results will need to be updated.
* Add regression tests for date, time, and time with time zone types.Thomas G. Lockhart2000-09-121-0/+68
Modify date->timestamp conversion to use mktime(). This should do better than before around Daylight Savings Time transitions.