From: Kumar <sgnerd@yahoo.com.sg>
To: psql <pgsql-sql@postgresql.org>
Subject: Problem with timestamp - Pls help
Date: Fri, 19 Sep 2003 18:44:36 +0530
Message-ID: <038501c37eaf$ff68a310$7502a8c0@hdsc.com> (raw)
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
wats=# select to_timestamp(substr(now(),1,22));
ERROR: Function to_timestamp(text) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
wats=# select date(substr(now(),1,22));
date
------------
2003-09-19
(1 row)
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
Please help me with this.
Regards
Senthil Kumar S
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg
Subject: Re: Problem with timestamp - Pls help
In-Reply-To: <038501c37eaf$ff68a310$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox