Message-ID: <3F6B0CCA.8030001@klaster.net>
Date: Fri, 19 Sep 2003 16:03:54 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
	rv:1.5a) Gecko/20030718
MIME-Version: 1.0
To: Kumar <sgnerd@yahoo.com.sg>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: Problem with timestamp - Pls help
References: <038501c37eaf$ff68a310$7502a8c0@hdsc.com>
In-Reply-To: <038501c37eaf$ff68a310$7502a8c0@hdsc.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


> Dear Friends,
>  
> I am using Postgres 7.3.4 on Linux server 7.3.
>  
> I wanted to update one column of my table with now() or timestamp. And I 
> want that timestamp of format ------------------------
>  2003-09-19 18:39:08.13
>  
> To achieve this I have used the following
>  
> wats=# select now();
>              now
> ------------------------------
>  2003-09-19 18:39:58.62398+00
> (1 row)
>  
> wats=# select substr(now(),1,22);
>          substr
> ------------------------
>  2003-09-19 18:40:01.25
> (1 row)
>  
> wats=# select timestamp(substr(now(),1,22));
> ERROR:  parser: parse error at or near "substr" at character 18
select substr(now(),1,22)::timestamp
or
select cast(substr(now(),1,22) as timestamp)

> Also I cant directly update my timestamp column as follows
>  
> 
> update "WATS".users set to_rec_modified_date = substr(now(),1,22);
> 
> ERROR:  column "rec_modified_date" is of type timestamp without time 
> zone but expression is of type text
>  You will need to rewrite or cast the expression
Use syntax above.

Regards,
Tomasz Myrta