Open timwis opened 8 years ago
EXTRACT(YEAR FROM field_name) and EXTRACT(MONTH FROM field_name) etc. work, but they're a bit different from date_trunc_ym(). DATE_FORMAT() doesn't seem to work.
EXTRACT(YEAR FROM field_name)
EXTRACT(MONTH FROM field_name)
date_trunc_ym()
DATE_FORMAT()
EXTRACT(YEAR FROM field_name)
andEXTRACT(MONTH FROM field_name)
etc. work, but they're a bit different fromdate_trunc_ym()
.DATE_FORMAT()
doesn't seem to work.