Convert bigint into date

iceberg100
iceberg100 used Ask the Experts™
on
how can I convert bigint record into date in postgres? E.g, select time from table; but, I would like to select that field and convert it into date, so that select result would be date, and not bigint.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Actually i would like to also know how to convert bigint into date in postgreSQL? Is it possible?

Author

Commented:
I have changed the original question so you can ignore my previous comment. Any kind of help would be appreciate ... :)
what is in your bigint.  Presume that it's seconds from the 1st Computer Epoch then the following should assist you

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_24282739.html
fridomCEO/Programmer

Commented:
What should this bigint present? From where on do you like to "calculate" this number?
Wouldn't it be more rational to us the Postgresql functions for Date handling?

Author

Commented:
Tnx!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial