Re: convert column of integer type to time type? - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: convert column of integer type to time type?
Date
Msg-id 0EF72AB1-0FD2-4251-891A-C0F2DA38DA40@seespotcode.net
Whole thread Raw
In response to convert column of integer type to time type?  (Carol Cheung <cacheung@consumercontact.com>)
Responses Re: convert column of integer type to time type?  (Carol Cheung <cacheung@consumercontact.com>)
List pgsql-novice
On Jun 27, 2007, at 10:36 , Carol Cheung wrote:

> My question is: Is it possible to alter the 'some_int' column
> directly without having to create a temporary 'some_time' holding
> column?

Are you trying to alter the table to replace your some_int column
with a some_time column? I believe you can do this in two steps.

SELECT *
FROM some_data;
some_int
----------
        12
       345
      1622
         1
(4 rows)

ALTER TABLE some_data
ALTER some_int TYPE TIME WITHOUT TIME ZONE
       USING CAST(to_char(some_int, 'FM99909:99') AS TIME WITHOUT
TIME ZONE);

ALTER TABLE some_data
RENAME some_int TO some_time;

SELECT *
FROM some_data;
some_time
-----------
00:12:00
03:45:00
16:22:00
00:01:00
(4 rows)

Hope this helps.

Michael Glaesemann
grzm seespotcode net



pgsql-novice by date:

Previous
From: Carol Cheung
Date:
Subject: convert column of integer type to time type?
Next
From: Carol Cheung
Date:
Subject: Re: convert column of integer type to time type?