On 15/08/15 13:06, Dickson S. Guedes wrote:
> 2015-08-14 21:32 GMT-03:00 Gavin Flower <GavinFlower@archidevsys.co.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!
I would go with 'halfyear', but I don't have a use case for it, so don't
put too much weight on my opinion of this!