Re: Timestamp vs. Interval and formatting....

On Jan 5, 2004, at 12:13 AM, Michael Glaesemann wrote:

> Hi Dan,
>
> On Jan 4, 2004, at 7:30 PM, Dan Jewett wrote:
>
>> On Sun, 4 Jan 2004 14:47:49 -0600, Michael Glaesemann wrote this well
>> considered message:
>
> You certainly know how to flatter a guy! :)
>
>> Now I just have the issue of resetting all those times I already
>> entered which were HH:MM instead of MM:SS.
>
> This is just thinking out loud: I haven't tried it. Can you do
> something like this?
>
> UPDATE track_length SET length = (
>     SELECT EXTRACT(hour FROM length)::min + EXTRACT(min FROM length)::sec
>     FROM track_length);

On second thought, I think this SELECT isn't specific enough. This
should be better:

UPDATE track_length
SET length = (EXTRACT(hour FROM length)::min + EXTRACT(min FROM
LENGTH)::sec)

Still not sure of the casts, but I think it's closer.

Michael Glaesemann
grzm myrealbox com