Not sure if this'll help you, but I like to store my dates/times using this format: date("Y-m-d H:i:s") It's always a 19 character string, so you could use the substr function to get different parts of the date. substr(date("Y-m-d H:i:s"),0,4) would get the year, for example. Hope this helps. -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php