timestamp.out

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

           | THURSDAY Thursday thursday FEBRUARY February february II
           | FRIDAY Friday friday FEBRUARY February february II
           | SATURDAY Saturday saturday FEBRUARY February february II
           | SUNDAY Sunday sunday FEBRUARY February february II
           | TUESDAY Tuesday tuesday FEBRUARY February february II
           | SATURDAY Saturday saturday FEBRUARY February february II
           | THURSDAY Thursday thursday FEBRUARY February february II
           | TUESDAY Tuesday tuesday FEBRUARY February february II
           | SATURDAY Saturday saturday FEBRUARY February february II
           | THURSDAY Thursday thursday FEBRUARY February february II
           | TUESDAY Tuesday tuesday FEBRUARY February february II
           | SUNDAY Sunday sunday FEBRUARY February february II
           | SATURDAY Saturday saturday FEBRUARY February february II
           | WEDNESDAY Wednesday wednesday FEBRUARY February february II
           | THURSDAY Thursday thursday FEBRUARY February february II
           | FRIDAY Friday friday MARCH March march III
           | MONDAY Monday monday DECEMBER December december XII
           | TUESDAY Tuesday tuesday DECEMBER December december XII
           | WEDNESDAY Wednesday wednesday JANUARY January january I
           | FRIDAY Friday friday FEBRUARY February february II
           | SATURDAY Saturday saturday MARCH March march III
           | TUESDAY Tuesday tuesday DECEMBER December december XII
           | WEDNESDAY Wednesday wednesday DECEMBER December december XII
           | FRIDAY Friday friday DECEMBER December december XII
           | SATURDAY Saturday saturday JANUARY January january I
           | SUNDAY Sunday sunday DECEMBER December december XII
           | MONDAY Monday monday JANUARY January january I
(64 rows)

SELECT '' AS to_char_3, to_char(d1, 'Y,YYY YYYY YYY YY Y CC Q MM WW DDD DD D J')
   FROM TIMESTAMP_TBL;
 to_char_3 |                     to_char                     
-----------+-------------------------------------------------
           | 
           | 
           | 1,970 1970 970 70 0 20 1 01 01 001 01 5 2440588
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 01 01 002 02 5 2450451
           | 1,997 1997 997 97 7 20 1 01 01 002 02 5 2450451
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 2 06 23 161 10 3 2450610
           | 2,001 2001 001 01 1 21 3 09 38 265 22 7 2452175
           | 2,000 2000 000 00 0 21 1 03 11 075 15 4 2451619
           | 2,000 2000 000 00 0 21 1 03 11 075 15 4 2451619
           | 2,000 2000 000 00 0 21 1 03 11 075 15 4 2451619
           | 2,000 2000 000 00 0 21 1 03 11 075 15 4 2451619
           | 2,000 2000 000 00 0 21 1 03 11 075 15 4 2451619
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 2 06 23 161 10 3 2450610
           | 1,997 1997 997 97 7 20 1 02 06 041 10 2 2450490
           | 1,997 1997 997 97 7 20 1 02 06 042 11 3 2450491
           | 1,997 1997 997 97 7 20 1 02 07 043 12 4 2450492
           | 1,997 1997 997 97 7 20 1 02 07 044 13 5 2450493
           | 1,997 1997 997 97 7 20 1 02 07 045 14 6 2450494
           | 1,997 1997 997 97 7 20 1 02 07 046 15 7 2450495
           | 1,997 1997 997 97 7 20 1 02 07 047 16 1 2450496
           | 0,097 0097 097 97 7 01 1 02 07 047 16 3 1686042
           | 0,097 0097 097 97 7 01 1 02 07 047 16 7 1756536
           | 0,597 0597 597 97 7 06 1 02 07 047 16 5 1939157
           | 1,097 1097 097 97 7 11 1 02 07 047 16 3 2121778
           | 1,697 1697 697 97 7 17 1 02 07 047 16 7 2340924
           | 1,797 1797 797 97 7 18 1 02 07 047 16 5 2377448
           | 1,897 1897 897 97 7 19 1 02 07 047 16 3 2413972
           | 1,997 1997 997 97 7 20 1 02 07 047 16 1 2450496
           | 2,097 2097 097 97 7 21 1 02 07 047 16 7 2487021
           | 1,996 1996 996 96 6 20 1 02 09 059 28 4 2450142
           | 1,996 1996 996 96 6 20 1 02 09 060 29 5 2450143
           | 1,996 1996 996 96 6 20 1 03 09 061 01 6 2450144
           | 1,996 1996 996 96 6 20 4 12 53 365 30 2 2450448
           | 1,996 1996 996 96 6 20 4 12 53 366 31 3 2450449
           | 1,997 1997 997 97 7 20 1 01 01 001 01 4 2450450
           | 1,997 1997 997 97 7 20 1 02 09 059 28 6 2450508
           | 1,997 1997 997 97 7 20 1 03 09 060 01 7 2450509
           | 1,997 1997 997 97 7 20 4 12 52 364 30 3 2450813
           | 1,997 1997 997 97 7 20 4 12 53 365 31 4 2450814
           | 1,999 1999 999 99 9 20 4 12 53 365 31 6 2451544
           | 2,000 2000 000 00 0 21 1 01 01 001 01 7 2451545
           | 2,000 2000 000 00 0 21 4 12 53 366 31 1 2451910
           | 2,001 2001 001 01 1 21 1 01 01 001 01 2 2451911
(64 rows)

SELECT '' AS to_char_4, to_char(d1, 'FMY,YYY FMYYYY FMYYY FMYY FMY FMCC FMQ FMMM FMWW FMDDD FMDD FMD FMJ') 
   FROM TIMESTAMP_TBL;
 to_char_4 |                     to_char                     
-----------+-------------------------------------------------
           | 
           | 
           | 1,970 1970 970 70 0 20 1 1 1 1 1 5 2440588
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 1 1 2 2 5 2450451
           | 1,997 1997 997 97 7 20 1 1 1 2 2 5 2450451
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 2 6 23 161 10 3 2450610
           | 2,001 2001 001 01 1 21 3 9 38 265 22 7 2452175
           | 2,000 2000 000 00 0 21 1 3 11 75 15 4 2451619
           | 2,000 2000 000 00 0 21 1 3 11 75 15 4 2451619
           | 2,000 2000 000 00 0 21 1 3 11 75 15 4 2451619
           | 2,000 2000 000 00 0 21 1 3 11 75 15 4 2451619
           | 2,000 2000 000 00 0 21 1 3 11 75 15 4 2451619
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 2 6 23 161 10 3 2450610
           | 1,997 1997 997 97 7 20 1 2 6 41 10 2 2450490
           | 1,997 1997 997 97 7 20 1 2 6 42 11 3 2450491
           | 1,997 1997 997 97 7 20 1 2 7 43 12 4 2450492
           | 1,997 1997 997 97 7 20 1 2 7 44 13 5 2450493
           | 1,997 1997 997 97 7 20 1 2 7 45 14 6 2450494
           | 1,997 1997 997 97 7 20 1 2 7 46 15 7 2450495
           | 1,997 1997 997 97 7 20 1 2 7 47 16 1 2450496
           | 0,097 97 097 97 7 1 1 2 7 47 16 3 1686042
           | 0,097 97 097 97 7 1 1 2 7 47 16 7 1756536
           | 0,597 597 597 97 7 6 1 2 7 47 16 5 1939157
           | 1,097 1097 097 97 7 11 1 2 7 47 16 3 2121778
           | 1,697 1697 697 97 7 17 1 2 7 47 16 7 2340924
           | 1,797 1797 797 97 7 18 1 2 7 47 16 5 2377448
           | 1,897 1897 897 97 7 19 1 2 7 47 16 3 2413972
           | 1,997 1997 997 97 7 20 1 2 7 47 16 1 2450496
           | 2,097 2097 097 97 7 21 1 2 7 47 16 7 2487021
           | 1,996 1996 996 96 6 20 1 2 9 59 28 4 2450142
           | 1,996 1996 996 96 6 20 1 2 9 60 29 5 2450143
           | 1,996 1996 996 96 6 20 1 3 9 61 1 6 2450144
           | 1,996 1996 996 96 6 20 4 12 53 365 30 2 2450448
           | 1,996 1996 996 96 6 20 4 12 53 366 31 3 2450449
           | 1,997 1997 997 97 7 20 1 1 1 1 1 4 2450450
           | 1,997 1997 997 97 7 20 1 2 9 59 28 6 2450508
           | 1,997 1997 997 97 7 20 1 3 9 60 1 7 2450509
           | 1,997 1997 997 97 7 20 4 12 52 364 30 3 2450813
           | 1,997 1997 997 97 7 20 4 12 53 365 31 4 2450814
           | 1,999 1999 999 99 9 20 4 12 53 365 31 6 2451544
           | 2,000 2000 000 00 0 21 1 1 1 1 1 7 2451545
           | 2,000 2000 000 00 0 21 4 12 53 366 31 1 2451910
           | 2,001 2001 001 01 1 21 1 1 1 1 1 2 2451911
(64 rows)

SELECT '' AS to_char_5, to_char(d1, 'HH HH12 HH24 MI SS SSSS') 
   FROM TIMESTAMP_TBL;
 to_char_5 |       to_char        
-----------+----------------------
           | 
           | 
           | 12 12 00 00 00 0
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 02 63122
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 12 12 00 00 00 0
           | 03 03 03 04 05 11045
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 06 06 18 19 20 65960
           | 08 08 08 14 01 29641
           | 01 01 13 14 02 47642
           | 12 12 12 14 03 44043
           | 03 03 03 14 04 11644
           | 02 02 02 14 05 8045
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 00 63120
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 06 06 18 32 01 66721
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
           | 05 05 17 32 01 63121
(64 rows)

SELECT '' AS to_char_6, to_char(d1, E'"HH:MI:SS is" HH:MI:SS "\\"text between quote marks\\""') 
   FROM TIMESTAMP_TBL;
 to_char_6 |                     to_char                     
-----------+-------------------------------------------------
           | 
           | 
           | HH:MI:SS is 12:00:00 "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:02 "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 12:00:00 "text between quote marks"
           | HH:MI:SS is 03:04:05 "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:19:20 "text between quote marks"
           | HH:MI:SS is 08:14:01 "text between quote marks"
           | HH:MI:SS is 01:14:02 "text between quote marks"
           | HH:MI:SS is 12:14:03 "text between quote marks"
           | HH:MI:SS is 03:14:04 "text between quote marks"
           | HH:MI:SS is 02:14:05 "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:00 "text between quote marks"
           | HH:MI:SS is 05:32:01 "text between quote marks"