PostgreSQL field type for unix timestamp?

Viewed 50676

PostgreSQL field type for unix timestamp :

  • to store it as unix time stamp
  • to retrieve it as a unix timestamp as well.

Have been going through Date/Time Types postgreSQL V 9.1.


  • Is integer the best way to go!? (this is what I had done when I was using MySQL. Had used int(10))
3 Answers
Related