Cast: timestamp to integer
От
Michal Durys
Тема
Cast: timestamp to integer
Дата
Msg-id
20030612184455.577d0a6e.joe@anime.com.pl
Список
Дерево обсуждения
Re: Cast: timestamp to integer Weiping He <laser@pgsqldb.com>
Hello, I hope it's not a question for psql-novice. ;-) I'd like to convert timestamp and date fields to intergers. Unfortunately cast() says it's impossible: ERROR: Cannot cast type date to integer ERROR: Cannot cast type timestamp without time zone to integer I'm quite sure it should be possible somehow. After all timestamp is (AFAIR) number of seconds counted from 1970. I need it for example to caclulate average number of downloads of a given file a day. For the time being I came up with an ugly solution like this: SELECT id, name, counter, counter/(extract(years FROM age(date_add))*365 + extract(months FROM age(date_add))*30 + extract(days FROM age(date_add)) + 1) AS ratio FROM dnload_files WHERE counter>0; I will be much obliged for any suggestions. Thanks in advance. -- Joe
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата: