Re: Cast: timestamp to integer

Why not use EXTRACT ?

Arjen

> -----Oorspronkelijk bericht-----
> Van: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] Namens Rory Campbell-Lange
> Verzonden: donderdag 12 juni 2003 18:58
> Aan: Michal Durys
> CC: pgsql-general(at)postgresql(dot)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(at)anime(dot)com(dot)pl) wrote:
> > I'd like to convert timestamp and date fields to intergers.
> > Unfortunately cast() says it's impossible:
> --
> Rory Campbell-Lange
> <rory(at)campbell-lange(dot)net>
> <www.campbell-lange.net>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org