Part 1 of several - Converting a varchar to an interval

Поиск
Список
Период
Сортировка
От Shawn
Тема Part 1 of several - Converting a varchar to an interval
Дата
Msg-id 200803261556.54418.postgres@xmtservices.net
обсуждение исходный текст
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Shavonne Marietta Wijesinghe"
Дата:
Сообщение: Export Access 97 to PostgreSQL
Следующее
От: Shawn
Дата:
Сообщение: Question 2 Interval and timestamptz