How To update time in PSQL!!

admin

Administrator
Staff member
Hi!

I am getting error when update with current_time.
----
bandwidth=> select * from dummy1;
esn|status|us|ds| tdate|time
---+------+--+--+----------+----
12|on |12|23|04-19-2001| 9
13|on |14|25|04-19-2001| 9
14|on |14|25|04-19-2001| 9
12|on |17|25|04-19-2001| 10
13|off |17|25|04-19-2001| 10
(5 rows)

bandwidth=> update dummy1 set time=current_time where esn=12;
ERROR: Attribute 'time' is of type 'varchar' but expression is of type 'time' You will need to rewrite or cast the expression.

Can You help me in this same.
Thanks in Advance!
Tulasi
 
Back
Top