How To update time in PSQL!!

Anon

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

Anon

Most databases have a function to convert from one type to another. MySQL would have TIME_FORMAT(time, '<format string>). A lot of databases support the CAST (or CONVERT) functions. Try this and see if it works:

update dummy1 set time= CAST(current_time AS VARCHAR(25)) where esn=12;

Your database should have a function somewhere that allows you to convert the time to a compatable format.

Anon

Hi!

I tried with ur Suggession. But it is displaying like as follows.

bandwidth=> update dummy2 set tdate=CAST(current_time AS VARCHAR(25))where
bandwidth-> sno=1;
UPDATE 1
bandwidth=> select * from dummy2;
sno|tdate
---+-----
1|now
(1 row)

bandwidth=> select tdate from dummy2;

tdate

now
(1 row)

I want to dispaly showing of time..instead of that it displaying Now.

please,Can you Suggest me in this same above .

Thanks in Advance.

Tulasi

dcaillouet

One of the problems we have is that I have never used PSQL. I was just telling you what worked in the databases I was familiar with.

Would it be possible to make the field tdate in the dummy2 table be a time field instead of a varchar field. Then you wouldn't have to do any conversion. Is there a particular reason you need to store a date/time as a string?