Why not use EXTRACT ?
Arjen
> -----Oorspronkelijk bericht-----
> Van: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] Namens Rory Campbell-Lange
> Verzonden: donderdag 12 juni 2003 18:58
> Aan: Michal Durys
> CC: pgsql-general@postgresql.org
> Onderwerp: Re: [GENERAL] Cast: timestamp to integer
>
>
> select cast(to_char(current_timestamp, 'd') as integer)/5;
>
> On 12/06/03, Michal Durys (joe@anime.com.pl) wrote:
> > I'd like to convert timestamp and date fields to intergers.
> > Unfortunately cast() says it's impossible:
> --
> Rory Campbell-Lange
> <rory@campbell-lange.net>
> <www.campbell-lange.net>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org