📄 timestamp.out
字号:
| @ 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)SELECT '' AS "54", d1 as "timestamp", 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 TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 54 | timestamp | year | month | day | hour | minute | second ----+-----------------------------+------+-------+-----+------+--------+-------- | Thu Jan 01 00:00:00 1970 | 1970 | 1 | 1 | 0 | 0 | 0 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:02 1997 | 1997 | 2 | 10 | 17 | 32 | 2 | Mon Feb 10 17:32:01.40 1997 | 1997 | 2 | 10 | 17 | 32 | 1.4 | Mon Feb 10 17:32:01.50 1997 | 1997 | 2 | 10 | 17 | 32 | 1.5 | Mon Feb 10 17:32:01.60 1997 | 1997 | 2 | 10 | 17 | 32 | 1.6 | Thu Jan 02 00:00:00 1997 | 1997 | 1 | 2 | 0 | 0 | 0 | Thu Jan 02 03:04:05 1997 | 1997 | 1 | 2 | 3 | 4 | 5 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Tue Jun 10 17:32:01 1997 | 1997 | 6 | 10 | 17 | 32 | 1 | Sat Sep 22 18:19:20 2001 | 2001 | 9 | 22 | 18 | 19 | 20 | Wed Mar 15 08:14:01 2000 | 2000 | 3 | 15 | 8 | 14 | 1 | Wed Mar 15 13:14:02 2000 | 2000 | 3 | 15 | 13 | 14 | 2 | Wed Mar 15 12:14:03 2000 | 2000 | 3 | 15 | 12 | 14 | 3 | Wed Mar 15 03:14:04 2000 | 2000 | 3 | 15 | 3 | 14 | 4 | Wed Mar 15 02:14:05 2000 | 2000 | 3 | 15 | 2 | 14 | 5 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:00 1997 | 1997 | 2 | 10 | 17 | 32 | 0 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Tue Jun 10 18:32:01 1997 | 1997 | 6 | 10 | 18 | 32 | 1 | Mon Feb 10 17:32:01 1997 | 1997 | 2 | 10 | 17 | 32 | 1 | Tue Feb 11 17:32:01 1997 | 1997 | 2 | 11 | 17 | 32 | 1 | Wed Feb 12 17:32:01 1997 | 1997 | 2 | 12 | 17 | 32 | 1 | Thu Feb 13 17:32:01 1997 | 1997 | 2 | 13 | 17 | 32 | 1 | Fri Feb 14 17:32:01 1997 | 1997 | 2 | 14 | 17 | 32 | 1 | Sat Feb 15 17:32:01 1997 | 1997 | 2 | 15 | 17 | 32 | 1 | Sun Feb 16 17:32:01 1997 | 1997 | 2 | 16 | 17 | 32 | 1 | Sun Feb 16 17:32:01 1997 | 1997 | 2 | 16 | 17 | 32 | 1 | Wed Feb 28 17:32:01 1996 | 1996 | 2 | 28 | 17 | 32 | 1 | Thu Feb 29 17:32:01 1996 | 1996 | 2 | 29 | 17 | 32 | 1 | Fri Mar 01 17:32:01 1996 | 1996 | 3 | 1 | 17 | 32 | 1 | Mon Dec 30 17:32:01 1996 | 1996 | 12 | 30 | 17 | 32 | 1 | Tue Dec 31 17:32:01 1996 | 1996 | 12 | 31 | 17 | 32 | 1 | Wed Jan 01 17:32:01 1997 | 1997 | 1 | 1 | 17 | 32 | 1 | Fri Feb 28 17:32:01 1997 | 1997 | 2 | 28 | 17 | 32 | 1 | Sat Mar 01 17:32:01 1997 | 1997 | 3 | 1 | 17 | 32 | 1 | Tue Dec 30 17:32:01 1997 | 1997 | 12 | 30 | 17 | 32 | 1 | Wed Dec 31 17:32:01 1997 | 1997 | 12 | 31 | 17 | 32 | 1 | Fri Dec 31 17:32:01 1999 | 1999 | 12 | 31 | 17 | 32 | 1 | Sat Jan 01 17:32:01 2000 | 2000 | 1 | 1 | 17 | 32 | 1 | Sun Dec 31 17:32:01 2000 | 2000 | 12 | 31 | 17 | 32 | 1 | Mon Jan 01 17:32:01 2001 | 2001 | 1 | 1 | 17 | 32 | 1(54 rows)SELECT '' AS "54", d1 as "timestamp", date_part( 'quarter', d1) AS quarter, date_part( 'msec', d1) AS msec, date_part( 'usec', d1) AS usec FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 54 | timestamp | quarter | msec | usec ----+-----------------------------+---------+-------+---------- | Thu Jan 01 00:00:00 1970 | 1 | 0 | 0 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:02 1997 | 1 | 2000 | 2000000 | Mon Feb 10 17:32:01.40 1997 | 1 | 1400 | 1400000 | Mon Feb 10 17:32:01.50 1997 | 1 | 1500 | 1500000 | Mon Feb 10 17:32:01.60 1997 | 1 | 1600 | 1600000 | Thu Jan 02 00:00:00 1997 | 1 | 0 | 0 | Thu Jan 02 03:04:05 1997 | 1 | 5000 | 5000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Tue Jun 10 17:32:01 1997 | 2 | 1000 | 1000000 | Sat Sep 22 18:19:20 2001 | 3 | 20000 | 20000000 | Wed Mar 15 08:14:01 2000 | 1 | 1000 | 1000000 | Wed Mar 15 13:14:02 2000 | 1 | 2000 | 2000000 | Wed Mar 15 12:14:03 2000 | 1 | 3000 | 3000000 | Wed Mar 15 03:14:04 2000 | 1 | 4000 | 4000000 | Wed Mar 15 02:14:05 2000 | 1 | 5000 | 5000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:00 1997 | 1 | 0 | 0 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Tue Jun 10 18:32:01 1997 | 2 | 1000 | 1000000 | Mon Feb 10 17:32:01 1997 | 1 | 1000 | 1000000 | Tue Feb 11 17:32:01 1997 | 1 | 1000 | 1000000 | Wed Feb 12 17:32:01 1997 | 1 | 1000 | 1000000 | Thu Feb 13 17:32:01 1997 | 1 | 1000 | 1000000 | Fri Feb 14 17:32:01 1997 | 1 | 1000 | 1000000 | Sat Feb 15 17:32:01 1997 | 1 | 1000 | 1000000 | Sun Feb 16 17:32:01 1997 | 1 | 1000 | 1000000 | Sun Feb 16 17:32:01 1997 | 1 | 1000 | 1000000 | Wed Feb 28 17:32:01 1996 | 1 | 1000 | 1000000 | Thu Feb 29 17:32:01 1996 | 1 | 1000 | 1000000 | Fri Mar 01 17:32:01 1996 | 1 | 1000 | 1000000 | Mon Dec 30 17:32:01 1996 | 4 | 1000 | 1000000 | Tue Dec 31 17:32:01 1996 | 4 | 1000 | 1000000 | Wed Jan 01 17:32:01 1997 | 1 | 1000 | 1000000 | Fri Feb 28 17:32:01 1997 | 1 | 1000 | 1000000 | Sat Mar 01 17:32:01 1997 | 1 | 1000 | 1000000 | Tue Dec 30 17:32:01 1997 | 4 | 1000 | 1000000 | Wed Dec 31 17:32:01 1997 | 4 | 1000 | 1000000 | Fri Dec 31 17:32:01 1999 | 4 | 1000 | 1000000 | Sat Jan 01 17:32:01 2000 | 1 | 1000 | 1000000 | Sun Dec 31 17:32:01 2000 | 4 | 1000 | 1000000 | Mon Jan 01 17:32:01 2001 | 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 TIMESTAMP_TBL; to_char_1 | to_char -----------+------------------------------------------------------------------------------------------ | | | 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 | 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 TIMESTAMP_TBL; to_char_2 | to_char -----------+-------------------------------------------------------------- | | | 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 | 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 | 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 | 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 | MONDAY Monday monday FEBRUARY February february II | TUESDAY Tuesday tuesday FEBRUARY February february II | WEDNESDAY Wednesday wednesday FEBRUARY February february II⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -