MySQL data type question: timestamp versus integer to hold time

vharishankar · 07-07-2005, 08:17 PM

I am designing and programming a PHP/MySQL application that implements an interactive link directory application where users can register and submit links.

My question is simple. I am using a field to store the time of registration, time a link is submitted etc. in my tables in the MySQL database.

Which type is better for this field: integer or timestamp?

Tinkster · 07-07-2005, 08:26 PM

What would the integer represent, seconds since epoch? :}

Cheers,
Tink

vharishankar · 07-07-2005, 08:52 PM

Hmm... yes. The PHP time() function returns in seconds. To use timestamp I must convert it to a format.

I think integer is better, but what are the advantages of using timestamp over integer?

Tinkster · 07-07-2005, 08:58 PM

I suppose the advantage is that you can run a query and
get actual time & date out of it without a programatical
interface for data extraction. If via PHP is the only way
you'll ever be using the database integers should be just
fine... HIH

Cheers,
Tink

vharishankar · 07-07-2005, 09:01 PM

Thanks Tinkster. Yes. This database is specifically only for the PHP application.