timestamp.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 06:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"
(64 rows)

SELECT '' AS to_char_7, to_char(d1, 'HH24--text--MI--text--SS')
   FROM TIMESTAMP_TBL;
 to_char_7 |        to_char         
-----------+------------------------
           | 
           | 
           | 00--text--00--text--00
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--02
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 00--text--00--text--00
           | 03--text--04--text--05
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 18--text--19--text--20
           | 08--text--14--text--01
           | 13--text--14--text--02
           | 12--text--14--text--03
           | 03--text--14--text--04
           | 02--text--14--text--05
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--00
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 18--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
           | 17--text--32--text--01
(64 rows)

SELECT '' AS to_char_8, to_char(d1, 'YYYYTH YYYYth Jth') 
   FROM TIMESTAMP_TBL;
 to_char_8 |         to_char         
-----------+-------------------------
           | 
           | 
           | 1970TH 1970th 2440588th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450451st
           | 1997TH 1997th 2450451st
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450610th
           | 2001ST 2001st 2452175th
           | 2000TH 2000th 2451619th
           | 2000TH 2000th 2451619th
           | 2000TH 2000th 2451619th
           | 2000TH 2000th 2451619th
           | 2000TH 2000th 2451619th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450610th
           | 1997TH 1997th 2450490th
           | 1997TH 1997th 2450491st
           | 1997TH 1997th 2450492nd
           | 1997TH 1997th 2450493rd
           | 1997TH 1997th 2450494th
           | 1997TH 1997th 2450495th
           | 1997TH 1997th 2450496th
           | 0097TH 0097th 1686042nd
           | 0097TH 0097th 1756536th
           | 0597TH 0597th 1939157th
           | 1097TH 1097th 2121778th
           | 1697TH 1697th 2340924th
           | 1797TH 1797th 2377448th
           | 1897TH 1897th 2413972nd
           | 1997TH 1997th 2450496th
           | 2097TH 2097th 2487021st
           | 1996TH 1996th 2450142nd
           | 1996TH 1996th 2450143rd
           | 1996TH 1996th 2450144th
           | 1996TH 1996th 2450448th
           | 1996TH 1996th 2450449th
           | 1997TH 1997th 2450450th
           | 1997TH 1997th 2450508th
           | 1997TH 1997th 2450509th
           | 1997TH 1997th 2450813th
           | 1997TH 1997th 2450814th
           | 1999TH 1999th 2451544th
           | 2000TH 2000th 2451545th
           | 2000TH 2000th 2451910th
           | 2001ST 2001st 2451911th
(64 rows)

  
SELECT '' AS to_char_9, to_char(d1, 'YYYY A.D. YYYY a.d. YYYY bc HH:MI:SS P.M. HH:MI:SS p.m. HH:MI:SS pm') 
   FROM TIMESTAMP_TBL;   
 to_char_9 |                               to_char                               
-----------+---------------------------------------------------------------------
           | 
           | 
           | 1970 A.D. 1970 a.d. 1970 ad 12:00:00 A.M. 12:00:00 a.m. 12:00:00 am
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:02 P.M. 05:32:02 p.m. 05:32:02 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 12:00:00 A.M. 12:00:00 a.m. 12:00:00 am
           | 1997 A.D. 1997 a.d. 1997 ad 03:04:05 A.M. 03:04:05 a.m. 03:04:05 am
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 2001 A.D. 2001 a.d. 2001 ad 06:19:20 P.M. 06:19:20 p.m. 06:19:20 pm
           | 2000 A.D. 2000 a.d. 2000 ad 08:14:01 A.M. 08:14:01 a.m. 08:14:01 am
           | 2000 A.D. 2000 a.d. 2000 ad 01:14:02 P.M. 01:14:02 p.m. 01:14:02 pm
           | 2000 A.D. 2000 a.d. 2000 ad 12:14:03 P.M. 12:14:03 p.m. 12:14:03 pm
           | 2000 A.D. 2000 a.d. 2000 ad 03:14:04 A.M. 03:14:04 a.m. 03:14:04 am
           | 2000 A.D. 2000 a.d. 2000 ad 02:14:05 A.M. 02:14:05 a.m. 02:14:05 am
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:00 P.M. 05:32:00 p.m. 05:32:00 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 06:32:01 P.M. 06:32:01 p.m. 06:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 0097 B.C. 0097 b.c. 0097 bc 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 0097 A.D. 0097 a.d. 0097 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 0597 A.D. 0597 a.d. 0597 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1097 A.D. 1097 a.d. 1097 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1697 A.D. 1697 a.d. 1697 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1797 A.D. 1797 a.d. 1797 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1897 A.D. 1897 a.d. 1897 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 2097 A.D. 2097 a.d. 2097 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1996 A.D. 1996 a.d. 1996 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1996 A.D. 1996 a.d. 1996 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1996 A.D. 1996 a.d. 1996 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1996 A.D. 1996 a.d. 1996 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1996 A.D. 1996 a.d. 1996 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1997 A.D. 1997 a.d. 1997 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 1999 A.D. 1999 a.d. 1999 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 2000 A.D. 2000 a.d. 2000 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 2000 A.D. 2000 a.d. 2000 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
           | 2001 A.D. 2001 a.d. 2001 ad 05:32:01 P.M. 05:32:01 p.m. 05:32:01 pm
(64 rows)

-- TO_TIMESTAMP()
SELECT '' AS to_timestamp_1, to_timestamp('0097/Feb/16 --> 08:14:30', 'YYYY/Mon/DD --> HH:MI:SS');
 to_timestamp_1 |         to_timestamp         
----------------+------------------------------
                | Sat Feb 16 08:14:30 0097 PST
(1 row)

SELECT '' AS to_timestamp_2, to_timestamp('97/2/16 8:14:30', 'FMYYYY/FMMM/FMDD FMHH:FMMI:FMSS');
 to_timestamp_2 |         to_timestamp         
----------------+------------------------------
                | Sat Feb 16 08:14:30 0097 PST
(1 row)

SELECT '' AS to_timestamp_3, to_timestamp('1985 January 12', 'YYYY FMMonth DD');
 to_timestamp_3 |         to_timestamp