timestamp.out

来自「PostgreSQL7.4.6 for Linux」· OUT 代码 · 共 1,342 行 · 第 1/5 页

OUT
1,342 行
字号
12345
 15 |             d1              ----+-----------------------------    | -infinity    | Thu Jan 01 00:00:00 1970    | Tue Feb 16 17:32:01 0097 BC    | Sat Feb 16 17:32:01 0097    | Thu Feb 16 17:32:01 0597    | Tue Feb 16 17:32:01 1097    | Sat Feb 16 17:32:01 1697    | Thu Feb 16 17:32:01 1797    | Tue Feb 16 17:32:01 1897    | Wed Feb 28 17:32:01 1996    | Thu Feb 29 17:32:01 1996    | Fri Mar 01 17:32:01 1996    | Mon Dec 30 17:32:01 1996    | Tue Dec 31 17:32:01 1996    | Wed Jan 01 17:32:01 1997(15 rows)SELECT '' AS one, d1 FROM TIMESTAMP_TBL   WHERE d1 = timestamp without time zone '1997-01-02'; one |            d1            -----+--------------------------     | Thu Jan 02 00:00:00 1997(1 row)SELECT '' AS "63", d1 FROM TIMESTAMP_TBL   WHERE d1 != timestamp without time zone '1997-01-02'; 63 |             d1              ----+-----------------------------    | -infinity    | infinity    | Thu Jan 01 00:00:00 1970    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:02 1997    | Mon Feb 10 17:32:01.40 1997    | Mon Feb 10 17:32:01.50 1997    | Mon Feb 10 17:32:01.60 1997    | Thu Jan 02 03:04:05 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Jun 10 17:32:01 1997    | Sat Sep 22 18:19:20 2001    | Wed Mar 15 08:14:01 2000    | Wed Mar 15 13:14:02 2000    | Wed Mar 15 12:14:03 2000    | Wed Mar 15 03:14:04 2000    | Wed Mar 15 02:14:05 2000    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:00 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Jun 10 18:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Feb 11 17:32:01 1997    | Wed Feb 12 17:32:01 1997    | Thu Feb 13 17:32:01 1997    | Fri Feb 14 17:32:01 1997    | Sat Feb 15 17:32:01 1997    | Sun Feb 16 17:32:01 1997    | Tue Feb 16 17:32:01 0097 BC    | Sat Feb 16 17:32:01 0097    | Thu Feb 16 17:32:01 0597    | Tue Feb 16 17:32:01 1097    | Sat Feb 16 17:32:01 1697    | Thu Feb 16 17:32:01 1797    | Tue Feb 16 17:32:01 1897    | Sun Feb 16 17:32:01 1997    | Sat Feb 16 17:32:01 2097    | Wed Feb 28 17:32:01 1996    | Thu Feb 29 17:32:01 1996    | Fri Mar 01 17:32:01 1996    | Mon Dec 30 17:32:01 1996    | Tue Dec 31 17:32:01 1996    | Wed Jan 01 17:32:01 1997    | Fri Feb 28 17:32:01 1997    | Sat Mar 01 17:32:01 1997    | Tue Dec 30 17:32:01 1997    | Wed Dec 31 17:32:01 1997    | Fri Dec 31 17:32:01 1999    | Sat Jan 01 17:32:01 2000    | Sun Dec 31 17:32:01 2000    | Mon Jan 01 17:32:01 2001(63 rows)SELECT '' AS "16", d1 FROM TIMESTAMP_TBL   WHERE d1 <= timestamp without time zone '1997-01-02'; 16 |             d1              ----+-----------------------------    | -infinity    | Thu Jan 01 00:00:00 1970    | Thu Jan 02 00:00:00 1997    | Tue Feb 16 17:32:01 0097 BC    | Sat Feb 16 17:32:01 0097    | Thu Feb 16 17:32:01 0597    | Tue Feb 16 17:32:01 1097    | Sat Feb 16 17:32:01 1697    | Thu Feb 16 17:32:01 1797    | Tue Feb 16 17:32:01 1897    | Wed Feb 28 17:32:01 1996    | Thu Feb 29 17:32:01 1996    | Fri Mar 01 17:32:01 1996    | Mon Dec 30 17:32:01 1996    | Tue Dec 31 17:32:01 1996    | Wed Jan 01 17:32:01 1997(16 rows)SELECT '' AS "49", d1 FROM TIMESTAMP_TBL   WHERE d1 >= timestamp without time zone '1997-01-02'; 49 |             d1              ----+-----------------------------    | infinity    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:02 1997    | Mon Feb 10 17:32:01.40 1997    | Mon Feb 10 17:32:01.50 1997    | Mon Feb 10 17:32:01.60 1997    | Thu Jan 02 00:00:00 1997    | Thu Jan 02 03:04:05 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Jun 10 17:32:01 1997    | Sat Sep 22 18:19:20 2001    | Wed Mar 15 08:14:01 2000    | Wed Mar 15 13:14:02 2000    | Wed Mar 15 12:14:03 2000    | Wed Mar 15 03:14:04 2000    | Wed Mar 15 02:14:05 2000    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:00 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Jun 10 18:32:01 1997    | Mon Feb 10 17:32:01 1997    | Tue Feb 11 17:32:01 1997    | Wed Feb 12 17:32:01 1997    | Thu Feb 13 17:32:01 1997    | Fri Feb 14 17:32:01 1997    | Sat Feb 15 17:32:01 1997    | Sun Feb 16 17:32:01 1997    | Sun Feb 16 17:32:01 1997    | Sat Feb 16 17:32:01 2097    | Fri Feb 28 17:32:01 1997    | Sat Mar 01 17:32:01 1997    | Tue Dec 30 17:32:01 1997    | Wed Dec 31 17:32:01 1997    | Fri Dec 31 17:32:01 1999    | Sat Jan 01 17:32:01 2000    | Sun Dec 31 17:32:01 2000    | Mon Jan 01 17:32:01 2001(49 rows)SELECT '' AS "54", d1 - timestamp without time zone '1997-01-02' AS diff   FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 54 |                  diff                  ----+----------------------------------------    | @ 9863 days ago    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 2 secs    | @ 39 days 17 hours 32 mins 1.40 secs    | @ 39 days 17 hours 32 mins 1.50 secs    | @ 39 days 17 hours 32 mins 1.60 secs    | @ 0    | @ 3 hours 4 mins 5 secs    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 159 days 17 hours 32 mins 1 sec    | @ 1724 days 18 hours 19 mins 20 secs    | @ 1168 days 8 hours 14 mins 1 sec    | @ 1168 days 13 hours 14 mins 2 secs    | @ 1168 days 12 hours 14 mins 3 secs    | @ 1168 days 3 hours 14 mins 4 secs    | @ 1168 days 2 hours 14 mins 5 secs    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 159 days 18 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 40 days 17 hours 32 mins 1 sec    | @ 41 days 17 hours 32 mins 1 sec    | @ 42 days 17 hours 32 mins 1 sec    | @ 43 days 17 hours 32 mins 1 sec    | @ 44 days 17 hours 32 mins 1 sec    | @ 45 days 17 hours 32 mins 1 sec    | @ 45 days 17 hours 32 mins 1 sec    | @ 308 days 6 hours 27 mins 59 secs ago    | @ 307 days 6 hours 27 mins 59 secs ago    | @ 306 days 6 hours 27 mins 59 secs ago    | @ 2 days 6 hours 27 mins 59 secs ago    | @ 1 day 6 hours 27 mins 59 secs ago    | @ 6 hours 27 mins 59 secs ago    | @ 57 days 17 hours 32 mins 1 sec    | @ 58 days 17 hours 32 mins 1 sec    | @ 362 days 17 hours 32 mins 1 sec    | @ 363 days 17 hours 32 mins 1 sec    | @ 1093 days 17 hours 32 mins 1 sec    | @ 1094 days 17 hours 32 mins 1 sec    | @ 1459 days 17 hours 32 mins 1 sec    | @ 1460 days 17 hours 32 mins 1 sec(54 rows)-- Test casting within a BETWEEN qualifierSELECT '' AS "54", d1 - timestamp without time zone '1997-01-02' AS diff  FROM TIMESTAMP_TBL  WHERE d1 BETWEEN timestamp without time zone '1902-01-01'   AND timestamp without time zone '2038-01-01'; 54 |                  diff                  ----+----------------------------------------    | @ 9863 days ago    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 2 secs    | @ 39 days 17 hours 32 mins 1.40 secs    | @ 39 days 17 hours 32 mins 1.50 secs    | @ 39 days 17 hours 32 mins 1.60 secs    | @ 0    | @ 3 hours 4 mins 5 secs    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 159 days 17 hours 32 mins 1 sec    | @ 1724 days 18 hours 19 mins 20 secs    | @ 1168 days 8 hours 14 mins 1 sec    | @ 1168 days 13 hours 14 mins 2 secs    | @ 1168 days 12 hours 14 mins 3 secs    | @ 1168 days 3 hours 14 mins 4 secs    | @ 1168 days 2 hours 14 mins 5 secs    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec    | @ 39 days 17 hours 32 mins 1 sec
12345

timestamp.out - 源码说明

本页面展示了「PostgreSQL7.4.6 for Linux」中的 timestamp.out 源码文件，采用 OUT 编程语言编写，共 1,342 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与PostgreSQL相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?