오늘 배운것들.
PostgreSQL에서 시간과 날짜 표현하기.
domaindb=> SELECT NOW();
now
-------------------------------
2008-07-27 22:18:36.410613+09
(1 row)
domaindb=> SELECT NOW()::ABSTIME::DATE::TEXT;
now
------------
2008-07-27
(1 row)
domaindb=> SELECT NOW()::ABSTIME::TIMESTAMP::TEXT;
now
---------------------
2008-07-27 22:18:54
(1 row)
domaindb=> SELECT DATE_PART('YEAR', NOW());
date_part
-----------
2008
(1 row)
domaindb=> SELECT DATE_PART('MONTH', NOW());
date_part
-----------
7
(1 row)
domaindb=> SELECT DATE_PART('DAY', NOW());
date_part
-----------
27
(1 row)
domaindb=> SELECT DATE_PART('YEAR', NOW()) AS year, DATE_PART('MONTH', NOW()) AS month, DATE_PART('day', NOW()) AS day;
year | month | day
------+-------+-----
2008 | 7 | 27
(1 row)
domaindb=> SELECT NOW()::ABSTIME::INT;
now
------------
1217164953
(1 row)
domaindb=> SELECT 1217164953::ABSTIME::DATE::TEXT;
text
------------
2008-07-27
(1 row)
domaindb=> SELECT NOW()::ABSTIME::DATE::TEXT AS date, NOW()::ABSTIME::TIME::TEXT AS time, NOW()::ABSTIME::TIMESTAMP::TEXT AS timestamp;
date | time | timestamp
------------+----------+---------------------
2008-07-27 | 22:38:32 | 2008-07-27 22:38:32
이올린에 북마크하기
이올린에 추천하기
