postgre timestamp type

admin

Administrator
Staff member
I am timestamping a page and trying to insert the timestamp into the DB. I want to keep the time in native format and then convert it to some more pleasant on the way out.
The data type is set in the db as 'timestamp'.
Here is the error I get when trying to insert the timestamp into the DB:

ERROR: Bad timestamp external representation

Here is the timestamp that I am trying to insert: 981528638

I have no problem converting this to the format I want before inserting it into the database. Am I using the wrong datatype to store it?
 
Back
Top