On Thu, May 29, 2008 at 07:01:46AM +0000, Jeferson Kasper wrote:
> the EXTRACT(field FROM source) function allows to use some kind of 'fields',
> and i need to know if a time (like '07:00') is after the midday(12:00) or
> not.
> I know i can resolve it implementing some function like "select
> ('07:00'<'12:00')".. i just want to know if is difficult to implement a new
> field called 'am', to use like.
>
> select extract(AM from '07:00');
What's wrong with just doing:
SELECT extract(hour FROM date) < 12;
Sam