[philzilla]

what's the preferred method with y'all? which do you find plays best with php:

timestamp or datetime?

examples would be nice with your answers

[madmacgames]

I always use datetime. one reason is, that sometimes I will browse through the database or manually enter some rows in the database, and a timestamp really does me no good on a date or date/time field.

I guess it would really not matter, because it PHP, you can pretty easily convert from one to the other if needed.

I guess I prefer datetime because like I said, it is human readable.

[Simon Mundy]

Originally posted by philzilla:
what's the preferred method with y'all? which do you find plays best with php:

timestamp or datetime?

examples would be nice with your answers

Datetime - it's much easier to read when I'm browsing through records with phpmyadmin!

These days I'm using Smarty more often than not, and it prefers a unix timestamp for its date_format conversion, so I'll always perform an SQL like:

SELECT UNIX_TIMESTAMP(date_created) FROM table

when I'm retrieving, then an

INSERT INTO table (date_created) VALUES (".date('Y-m-d h:i:s',$timestamp)

when I put it back

This way I can also utilise native SQL date functions and they'll perform as expected

[philzilla]

always good to hear other opinions match your own

cheers, guys.

[sambeau]

Originally posted by philzilla:
always good to hear other opinions match your own

cheers, guys.

Don't use TIMESTAMP as it will change if you modify any other data in that row (unless that's what you want).