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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
