Cast: timestamp to integer
| От | Michal Durys |
|---|---|
| Тема | Cast: timestamp to integer |
| Дата | |
| Msg-id | 20030612184455.577d0a6e.joe@anime.com.pl обсуждение исходный текст |
| Ответы |
Re: Cast: timestamp to integer
Re: Cast: timestamp to integer Re: Cast: timestamp to integer |
| Список | pgsql-general |
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 <joe@anime.com.pl>
В списке pgsql-general по дате отправления: