Ken Tanzer <ken.tanzer@xxxxxxxxx> writes: > Not really. My original question was: >> [since intervals are stored internally as months, days and microseconds...] >> What Postgres actually stores for an interval is three fields: >> months, days, and microseconds. >> *Is there a way to view/extract this raw data for any given interval?* Given what extract() provides, stored months = years * 12 + months stored days = days stored usec = reconstruct from hours+minutes+seconds+microseconds Perhaps it wouldn't be a bad idea to provide a couple more extract() keywords to make that easier. regards, tom lane
