In PHP/MySQL I always set timestamps in unix time ( time() ) - it makes it very easy to format into any notation (see the date() function) including allowing for time zone, is sequential by default and you can add and subtract seconds/hours/days/weeks/months very easily. Store it in an INT 11 field.