Forum OpenACS Q&A: Date as non-obvious numbers

Collapse
1: Date as non-obvious numbers
Posted by Bob OConnor on 10/24/01 11:08 PM

I need a fixed non obvious number that I could get from a PG date. Instead of the obvious date time: 20011024160045, I would like a raw number from a date ... something like seconds since 1970 or similar... It would be reproducable but not known to the casual observer that it is a date. My brief search through the postgresql docs come up with nothing....

Thanks -Bob

Collapse
2: Response to Date as non-obvious numbers (response to 1)
Posted by Don Baccus on 10/25/01 02:13 AM
Try this: 
select date_part('epoch', current_timestamp);