2015-08-14 21:32 GMT-03:00 Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>:
...
> So semesters don't appear to align with normal half year boundaries.
Interesting links, thanks!
Which sounds better for a native English: 'half', 'halfyear'?
For example:
> SELECT date_trunc('halfyear', current_date);
date_trunc
------------------------
2015-07-01 00:00:00-03
(1 row)
Thanks!
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br