Re: casting interval to time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: casting interval to time
Date: 2003-06-16 14:53:51
Message-ID: 2971.1055775231@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tomasz Myrta <jasiek(at)klaster(dot)net> writes:
> psql (PostgreSQL) 7.3.2
> SELECT cast(cast('1 day 12 hours' as interval) as time);
> time
> ----------
> 00:00:00
> (1 row)

I get 12:00:00 here, using 7.3.3 ... platform-specific problem maybe?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message BenLaKnet 2003-06-16 14:55:10 [pgmail] - I have problems with pgmail
Previous Message Manfred Koizar 2003-06-16 14:39:32 Re: Let join syntax