Skip site navigation (1) Skip section navigation (2)

Re: CAST and timestamp

From: Keith Worthington <KeithW(at)NarrowPathInc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: CAST and timestamp
Date: 2004-12-21 03:48:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Tom Lane wrote:

>"Keith Worthington" <keithw(at)narrowpathinc(dot)com> writes:
>>IPADB=# SELECT CAST(scan_date || scan_time AS timestamp) AS datetime_timestamp
>>FROM data_transfer.tbl_inventory_scanner;
>>ERROR:  Cannot cast type character to timestamp without time zone
>>IPADB=# SELECT employee_id, item_id, CAST(quantity AS float4) AS quantity FROM
>>ERROR:  Cannot cast type character varying to real
>Try casting the inputs to type "text" and then to timestamp or real.
>			regards, tom lane
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend

Are you saying that I should try something like

CAST( CAST( quantity AS text ) AS float4) AS quantity

Kind Regards,

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2004-12-21 04:02:37
Subject: Re: CAST and timestamp
Previous:From: Tom LaneDate: 2004-12-21 03:45:26
Subject: Re: Inheritance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group