8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST 95 Chapter 8. Data Types interval output looks like the reasons returns a text string rather than a timestamp value: SELECT timeofday(); Result: Sat Feb 17 19:07:32.000126 2001 EST It is important to know that CURRENT_TIMESTAMP and related functions return the

standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST 90 Chapter 8. Data Types Style Specification Description Example POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL and POSTGRES styles, day appears before month if DMY field ordering has been spec- ified, otherwise month appears before day. (See Section day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST interval output looks like the input format, except that For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST The date/time styles can be selected by the user using For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval

8601/SQL standard 1997-12-17 07:37:16-08 SQL traditional style 12/17/1997 07:37:16.00 PST POSTGRES original style Wed Dec 17 07:37:16 1997 PST German regional style 17.12.1997 07:37:16.00 PST In the SQL day/month/year 17/12/1997 15:37:16.00 CET SQL, MDY month/day/year 12/17/1997 07:37:16.00 PST Postgres, DMY day/month/year Wed 17 Dec 07:37:16 1997 PST The date/time styles can be selected by the user using For example, with the session time zone set to CST7CDT, timestamp with time zone ’2005-04-02 12:00-07’ + interval ’1 day’ will produce timestamp with time zone ’2005-04-03 12:00-06’, while adding interval