📄 timestamptz.out
字号:
| @ 1168 days 3 hours 14 mins 4 secs | @ 1168 days 1 hour 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 9 hours 32 mins 1 sec | @ 39 days 9 hours 32 mins 1 sec | @ 39 days 9 hours 32 mins 1 sec | @ 159 days 17 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)SELECT '' AS "54", d1 as timestamptz, date_part( 'year', d1) AS year, date_part( 'month', d1) AS month, date_part( 'day', d1) AS day, date_part( 'hour', d1) AS hour, date_part( 'minute', d1) AS minute, date_part( 'second', d1) AS second FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 54 | timestamptz | year | month | day | hour | minute | second ----+---------------------------------+------+-------+-----+------+--------+-------- | Wed Dec 31 16:00:00 1969 PST | 1969 | 12 | 31 | 16 | 0 | 0 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:02 1997 PST | 1997 | 2 | 10 | 17 | 32 | 2 | Mon Feb 10 17:32:01.40 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.4 | Mon Feb 10 17:32:01.50 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.5 | Mon Feb 10 17:32:01.60 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1.6 | Thu Jan 02 00:00:00 1997 PST | 1997 | 1 | 2 | 0 | 0 | 0 | Thu Jan 02 03:04:05 1997 PST | 1997 | 1 | 2 | 3 | 4 | 5 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Tue Jun 10 17:32:01 1997 PDT | 1997 | 6 | 10 | 17 | 32 | 1 | Sat Sep 22 18:19:20 2001 PDT | 2001 | 9 | 22 | 18 | 19 | 20 | Wed Mar 15 08:14:01 2000 PST | 2000 | 3 | 15 | 8 | 14 | 1 | Wed Mar 15 04:14:02 2000 PST | 2000 | 3 | 15 | 4 | 14 | 2 | Wed Mar 15 02:14:03 2000 PST | 2000 | 3 | 15 | 2 | 14 | 3 | Wed Mar 15 03:14:04 2000 PST | 2000 | 3 | 15 | 3 | 14 | 4 | Wed Mar 15 01:14:05 2000 PST | 2000 | 3 | 15 | 1 | 14 | 5 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:00 1997 PST | 1997 | 2 | 10 | 17 | 32 | 0 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1 | Mon Feb 10 09:32:01 1997 PST | 1997 | 2 | 10 | 9 | 32 | 1 | Tue Jun 10 18:32:01 1997 PDT | 1997 | 6 | 10 | 18 | 32 | 1 | Mon Feb 10 17:32:01 1997 PST | 1997 | 2 | 10 | 17 | 32 | 1 | Tue Feb 11 17:32:01 1997 PST | 1997 | 2 | 11 | 17 | 32 | 1 | Wed Feb 12 17:32:01 1997 PST | 1997 | 2 | 12 | 17 | 32 | 1 | Thu Feb 13 17:32:01 1997 PST | 1997 | 2 | 13 | 17 | 32 | 1 | Fri Feb 14 17:32:01 1997 PST | 1997 | 2 | 14 | 17 | 32 | 1 | Sat Feb 15 17:32:01 1997 PST | 1997 | 2 | 15 | 17 | 32 | 1 | Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 | 1 | Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 | 1 | Wed Feb 28 17:32:01 1996 PST | 1996 | 2 | 28 | 17 | 32 | 1 | Thu Feb 29 17:32:01 1996 PST | 1996 | 2 | 29 | 17 | 32 | 1 | Fri Mar 01 17:32:01 1996 PST | 1996 | 3 | 1 | 17 | 32 | 1 | Mon Dec 30 17:32:01 1996 PST | 1996 | 12 | 30 | 17 | 32 | 1 | Tue Dec 31 17:32:01 1996 PST | 1996 | 12 | 31 | 17 | 32 | 1 | Wed Jan 01 17:32:01 1997 PST | 1997 | 1 | 1 | 17 | 32 | 1 | Fri Feb 28 17:32:01 1997 PST | 1997 | 2 | 28 | 17 | 32 | 1 | Sat Mar 01 17:32:01 1997 PST | 1997 | 3 | 1 | 17 | 32 | 1 | Tue Dec 30 17:32:01 1997 PST | 1997 | 12 | 30 | 17 | 32 | 1 | Wed Dec 31 17:32:01 1997 PST | 1997 | 12 | 31 | 17 | 32 | 1 | Fri Dec 31 17:32:01 1999 PST | 1999 | 12 | 31 | 17 | 32 | 1 | Sat Jan 01 17:32:01 2000 PST | 2000 | 1 | 1 | 17 | 32 | 1 | Sun Dec 31 17:32:01 2000 PST | 2000 | 12 | 31 | 17 | 32 | 1 | Mon Jan 01 17:32:01 2001 PST | 2001 | 1 | 1 | 17 | 32 | 1(54 rows)SELECT '' AS "54", d1 as timestamptz, date_part( 'quarter', d1) AS quarter, date_part( 'msec', d1) AS msec, date_part( 'usec', d1) AS usec FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 54 | timestamptz | quarter | msec | usec ----+---------------------------------+---------+-------+---------- | Wed Dec 31 16:00:00 1969 PST | 4 | 0 | 0 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:02 1997 PST | 1 | 2000 | 2000000 | Mon Feb 10 17:32:01.40 1997 PST | 1 | 1400 | 1400000 | Mon Feb 10 17:32:01.50 1997 PST | 1 | 1500 | 1500000 | Mon Feb 10 17:32:01.60 1997 PST | 1 | 1600 | 1600000 | Thu Jan 02 00:00:00 1997 PST | 1 | 0 | 0 | Thu Jan 02 03:04:05 1997 PST | 1 | 5000 | 5000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Tue Jun 10 17:32:01 1997 PDT | 2 | 1000 | 1000000 | Sat Sep 22 18:19:20 2001 PDT | 3 | 20000 | 20000000 | Wed Mar 15 08:14:01 2000 PST | 1 | 1000 | 1000000 | Wed Mar 15 04:14:02 2000 PST | 1 | 2000 | 2000000 | Wed Mar 15 02:14:03 2000 PST | 1 | 3000 | 3000000 | Wed Mar 15 03:14:04 2000 PST | 1 | 4000 | 4000000 | Wed Mar 15 01:14:05 2000 PST | 1 | 5000 | 5000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:00 1997 PST | 1 | 0 | 0 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 09:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 09:32:01 1997 PST | 1 | 1000 | 1000000 | Mon Feb 10 09:32:01 1997 PST | 1 | 1000 | 1000000 | Tue Jun 10 18:32:01 1997 PDT | 2 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 PST | 1 | 1000 | 1000000 | Tue Feb 11 17:32:01 1997 PST | 1 | 1000 | 1000000 | Wed Feb 12 17:32:01 1997 PST | 1 | 1000 | 1000000 | Thu Feb 13 17:32:01 1997 PST | 1 | 1000 | 1000000 | Fri Feb 14 17:32:01 1997 PST | 1 | 1000 | 1000000 | Sat Feb 15 17:32:01 1997 PST | 1 | 1000 | 1000000 | Sun Feb 16 17:32:01 1997 PST | 1 | 1000 | 1000000 | Sun Feb 16 17:32:01 1997 PST | 1 | 1000 | 1000000 | Wed Feb 28 17:32:01 1996 PST | 1 | 1000 | 1000000 | Thu Feb 29 17:32:01 1996 PST | 1 | 1000 | 1000000 | Fri Mar 01 17:32:01 1996 PST | 1 | 1000 | 1000000 | Mon Dec 30 17:32:01 1996 PST | 4 | 1000 | 1000000 | Tue Dec 31 17:32:01 1996 PST | 4 | 1000 | 1000000 | Wed Jan 01 17:32:01 1997 PST | 1 | 1000 | 1000000 | Fri Feb 28 17:32:01 1997 PST | 1 | 1000 | 1000000 | Sat Mar 01 17:32:01 1997 PST | 1 | 1000 | 1000000 | Tue Dec 30 17:32:01 1997 PST | 4 | 1000 | 1000000 | Wed Dec 31 17:32:01 1997 PST | 4 | 1000 | 1000000 | Fri Dec 31 17:32:01 1999 PST | 4 | 1000 | 1000000 | Sat Jan 01 17:32:01 2000 PST | 1 | 1000 | 1000000 | Sun Dec 31 17:32:01 2000 PST | 4 | 1000 | 1000000 | Mon Jan 01 17:32:01 2001 PST | 1 | 1000 | 1000000(54 rows)-- TO_CHAR()SELECT '' AS to_char_1, to_char(d1, 'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon') FROM TIMESTAMPTZ_TBL; to_char_1 | to_char -----------+------------------------------------------------------------------------------------------ | | | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu JANUARY January january I JAN Jan jan | THURSDAY Thursday thursday THU Thu thu JANUARY January january I JAN Jan jan | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue JUNE June june VI JUN Jun jun | SATURDAY Saturday saturday SAT Sat sat SEPTEMBER September september IX SEP Sep sep | WEDNESDAY Wednesday wednesday WED Wed wed MARCH March march III MAR Mar mar | WEDNESDAY Wednesday wednesday WED Wed wed MARCH March march III MAR Mar mar | WEDNESDAY Wednesday wednesday WED Wed wed MARCH March march III MAR Mar mar | WEDNESDAY Wednesday wednesday WED Wed wed MARCH March march III MAR Mar mar | WEDNESDAY Wednesday wednesday WED Wed wed MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue JUNE June june VI JUN Jun jun | MONDAY Monday monday MON Mon mon FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb | TUESDAY Tuesday tuesday TUE Tue tue FEBRUARY February february II FEB Feb feb | SUNDAY Sunday sunday SUN Sun sun FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat FEBRUARY February february II FEB Feb feb | WEDNESDAY Wednesday wednesday WED Wed wed FEBRUARY February february II FEB Feb feb | THURSDAY Thursday thursday THU Thu thu FEBRUARY February february II FEB Feb feb | FRIDAY Friday friday FRI Fri fri MARCH March march III MAR Mar mar | MONDAY Monday monday MON Mon mon DECEMBER December december XII DEC Dec dec | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed JANUARY January january I JAN Jan jan | FRIDAY Friday friday FRI Fri fri FEBRUARY February february II FEB Feb feb | SATURDAY Saturday saturday SAT Sat sat MARCH March march III MAR Mar mar | TUESDAY Tuesday tuesday TUE Tue tue DECEMBER December december XII DEC Dec dec | WEDNESDAY Wednesday wednesday WED Wed wed DECEMBER December december XII DEC Dec dec | FRIDAY Friday friday FRI Fri fri DECEMBER December december XII DEC Dec dec | SATURDAY Saturday saturday SAT Sat sat JANUARY January january I JAN Jan jan | SUNDAY Sunday sunday SUN Sun sun DECEMBER December december XII DEC Dec dec | MONDAY Monday monday MON Mon mon JANUARY January january I JAN Jan jan(64 rows) SELECT '' AS to_char_2, to_char(d1, 'FMDAY FMDay FMday FMMONTH FMMonth FMmonth FMRM') FROM TIMESTAMPTZ_TBL; to_char_2 | to_char -----------+-------------------------------------------------------------- | | | WEDNESDAY Wednesday wednesday DECEMBER December december XII | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | THURSDAY Thursday thursday JANUARY January january I | THURSDAY Thursday thursday JANUARY January january I | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II | TUESDAY Tuesday tuesday JUNE June june VI | SATURDAY Saturday saturday SEPTEMBER September september IX | WEDNESDAY Wednesday wednesday MARCH March march III | WEDNESDAY Wednesday wednesday MARCH March march III | WEDNESDAY Wednesday wednesday MARCH March march III | WEDNESDAY Wednesday wednesday MARCH March march III | WEDNESDAY Wednesday wednesday MARCH March march III | MONDAY Monday monday FEBRUARY February february II | MONDAY Monday monday FEBRUARY February february II⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -