Cast: timestamp to integer - Mailing list 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>