| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | "alex b(dot)" <mailinglists1(at)gmx(dot)de> |
| Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: VARCHAR to TIME |
| Date: | 2003-05-13 22:12:18 |
| Message-ID: | 3EC16DC2.3060602@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
What are you using as a serving and streaming language? (not related to your question, I want to set up my MP3's like you have, and do it on my laptop)
alex b. wrote:
> 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
> ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2003-05-13 22:21:36 | Re: VARCHAR to TIME |
| Previous Message | Dennis Gearon | 2003-05-13 22:06:04 | Re: fomatting an interval (resend) |