Try:
processdata=> SELECT CURRENT_DATE - 28;
?column?
------------
2001-12-06
(1 row)
Thomas could probably explain why this is. I can't remember the
reasoning, I simply learned to stay away from these types of functions
(now(), current_date(), etc.).
Jason
"Ben-Nes Michael" <miki@canaan.co.il> writes:
> Hi All
>
> I was amazed that:
> select current_date() - 28 dont work at postgresql :(
>
> I checked here and there and found that in postgresql i need to do something
> like this:
>
> select current_date::TIMESTAMP - '28 days'::INTERVAL as date
>
> whow, is there a shorter way ?
>
> --------------------------
> Canaan Surfing Ltd.
> Internet Service Providers
> Ben-Nes Michael - Manager
> Tel: 972-4-6991122
> http://sites.canaan.co.il
> --------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org