VARCHAR to TIME

From: "alex b(dot)" <mailinglists1(at)gmx(dot)de>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: VARCHAR to TIME
Date: 2003-05-13 21:50:17
Message-ID: 3EC16899.3020508@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

I have a couple thousand mp3s with all their properties stored in a
table... the songlength is currently saved as varchar... now, after the
database is filled the thought crossed my mind to get the overall
playlength... well, a "sum()" won't work on varchars, obviously...

now, I'd like to port the varchars to the time format.. could someone
give me hints on accomplishing this task?

TIA

length | character varying(10) |

SELECT length FROM tmp3 ;
...
02:11
04:19
02:04
03:36
04:09
04:08
01:55
...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jay O'Connor 2003-05-13 21:58:34 executables when upgrading
Previous Message nolan 2003-05-13 21:22:56 Re: Creating functions and triggers