Re: [GENERAL] Hopefully simple date conversion question

2000-07-29 Thread Jason C. Pion
On Fri, 28 Jul 2000, Tom Lane wrote: > * convert the value to Unix timestamp notation (subtract off enough > days to make 0 correspond to 1/1/1970, then multiply by 24*60*60). > * coerce the resulting integer to abstime and then to whatever > datatype you want to use (timestamp or dat

[GENERAL] Hopefully simple date conversion question

2000-07-28 Thread Jason C. Pion
I have a legacy database that I am porting to PostgreSQL. One of the fields is an integer column that actually represents a date. It is represented as the number of days since July 1, 1867. What I am wondering is: Is there a function or other means of getting this integer converted into a real