我想 Select sql:
to_char(timestamp_column, 'YYYY-MM')
我想 Select sql:
to_char(timestamp_column, 'YYYY-MM')
date_part(text, timestamp)
例如
date_part('month', timestamp '2001-02-16 20:38:40'),
date_part('year', timestamp '2001-02-16 20:38:40')
http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html