Part 1 of several - Converting a varchar to an interval

From: Shawn <postgres(at)xmtservices(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Part 1 of several - Converting a varchar to an interval
Date: 2008-03-26 15:56:54
Message-ID: 200803261556.54418.postgres@xmtservices.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I have several large tables, over 100 million records each. One of the fields
is callee 'duration'. It is a varchar that contains what is essentially an
integer that is the duration of an event in milleseconds. Could someone tell
me a simple way to convert a value such as 134987 stored in a varchar into an
interval?

This will dovetail with my next question.

Thanks for all the help both now and previous.

Shawn

Browse pgsql-sql by date

  From Date Subject
Next Message Shawn 2008-03-26 16:05:56 Question 2 Interval and timestamptz
Previous Message Shavonne Marietta Wijesinghe 2008-03-26 11:46:43 Export Access 97 to PostgreSQL