Posted on 2007-11-05 12:03
skycity 閱讀(650)
評論(0) 編輯 收藏 所屬分類:
數據庫技術
這兩天又回過頭來弄postgresql發現了一個比較好用的函數
根據出生日期得到當前用戶年齡
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