Posted 26 October 2006 - 05:31 PM
Posted 26 October 2006 - 06:11 PM
I use UNIX timestamps, by using the time() function to get the timestamp of now or use strtotime to convert a date format into a time stamp, eg 12/06/2006 (dd/mm/yyyy) into a UNIX timestamp which produces the follow: 1165363200
I generally use INT as the data type when storing timestamps in MySQL. However you can use a TIMESTAMP as the data type if you want to. Its up to you when creating your database schema.
Posted 27 October 2006 - 05:00 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users