On 2/22/07, Ana Smail <anasmail(at)unnoba(dot)edu(dot)ar> wrote:
>
>
>
>
> Les consulto:
>
> Necesito que este SELECT:
>
> select current_date - interval '6 months'
>
>
>
> me devuelva un tipo date, no un TIMESTAMP. Cómo hago?
>
select cast(current_date - interval '6 months' as date);
>
>
> Gracias por su ayuda.
>
>
>
> ANA
--
"Linux is for people who hate Windows, BSD is for people who love UNIX"
"Social Engineer -> Because there is no patch for human stupidity"