[postgis-users] OT: Coverting time_t to timestamp

[Paul Tomblin]

Sorry about the off topic posting, but does anybody know a cleaner way to 
convert a Unix time_t date to timestamp than
	select '1970-01-01'::timestamp + interval '1207360519 seconds';

-- 
Paul Tomblin <ptomblin at xcski.com> http://blog.xcski.com/
Knuth is definitely the bastard something from hell. I just admire him
from a distance, it's safer.
               -- Peter da Silva