Is there a default value, Unix timestamp, for column in PostgreSQL?

Question

I don't know why, but I like to work with Unix-timestamp. Maybe because I need to perform calculations with time like with number, e.g. time()-604800.

Right now I have integer column whereto I insert result of time(). I think it isn't right way, is it? Is there a default value -- unix timestamp?

ThiefMaster · Accepted Answer · 2012-04-24 08:11:36Z

10

You should get rid of the habit of using unix timestamps in your database. PostgreSQL has really awesome date functions such as datetimecol - interval '1 week'. It can also easily convert to unix timestamps using extract(epoch from datetimecol).

Anyway, you can use extract(epoch from now()) as the default value of your column.

answered Apr 24, 2012 at 8:11

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

anony_root Over a year ago

I think it's from MySQL, before I've been using it and I didn't like time functions in it. And recently I've decided that MySQL doesn't fit my needs and I've chose PgSql. :)

ThiefMaster Over a year ago

Guessed so. Take it as a reason to get away from bad habits. In case you are using PHP also start using PDO or at least pg_query_params() instead of escaping.

kgrittn Over a year ago

Be sure to use TIMESTAMP WITH TIME ZONE (also known as timestamptz); the default TIMESTAMP (which is "WITHOUT TIME ZONE") does not represent a moment in time.

Collectives™ on Stack Overflow

Is there a default value, Unix timestamp, for column in PostgreSQL?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related