Posted on 2007-11-05 12:03
skycity 閱讀(646)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
數(shù)據(jù)庫(kù)技術(shù)
這兩天又回過(guò)頭來(lái)弄postgresql發(fā)現(xiàn)了一個(gè)比較好用的函數(shù)
根據(jù)出生日期得到當(dāng)前用戶(hù)年齡
elein=# SELECT age('12/31/1959'::timestamp);
????????? age??????????
------------------------
43 years 7 mons 8 days
elein=# SELECT extract(year FROM age('12/31/1959'::timestamp));
date_part
-----------
??????? 43
elein=# SELECT extract(days FROM age('12/31/1959'::timestamp));
date_part
-----------
???????? 8
SELECT extract(days FROM age('12/31/1959'::timestamp));
?? date_trunc??????
------------------------
43 years 7 mons 8 days
=# SELECT date_trunc('months' ,age('12/31/1959'::timestamp));
?? date_trunc???
-----------------
43 years 7 mons
=# SELECT date_trunc('years' , age('12/31/1959'::timestamp));
date_trunc
------------
43 years
Lyyb2001