Postgres Pro
Downloads
Home   >   mailing lists

Re: Cast: timestamp to integer - Mailing list pgsql-general

From Rory Campbell-Lange
Subject Re: Cast: timestamp to integer
Date
Msg-id 20030612165750.GC29267@campbell-lange.net
Whole thread Raw
In response to Cast: timestamp to integer  (Michal Durys <joe@anime.com.pl>)
Responses Re: Cast: timestamp to integer  (Arjen van der Meijden <acm@tweakers.net>)
List pgsql-general
Tree view 
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>

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: Csaba Nagy
Date:
Subject: Re: Cast: timestamp to integer