RE: [PHP] Timestamp and MySQL

- point your Web browser to http://www.php.net/search.php - write in 'search for' field: php mysql timestamp - chose 'restrict the search to' "PHP General Mailing List" entry - click 'go' - you'll find over 1000 messages regarding the search keywords - however you'll find the answer on the first page (first ten messages, OK, Bruce Christensen mail) already - in that way not only your problem will be resolved but you'll learn how to resolve problems by yourself Maciek > -----Original Message----- > From: Glen Ogilvie [mailto:nelg@geocities.com] > Sent: Monday, August 07, 2000 12:41 PM > To: PHP General Mailing List > Subject: [PHP] Timestamp and MySQL > > > > Hi everyone, > > I have discovered an annoying thing with MySQL and PHP. When I > create a table > in MySQL with a column using TIMESTAMP, it stores a timestamp in > the format of > yyyymmddhhmmss, rather than the standard unix timestamp. This > means that I then > cannot use the time functions in PHP to work with it. Is the a > function in > PHP, or MySQL to persuade them to both understand the same format? > > If not, I can manage by just writing the date into MySQL > manually, but it's messy. > > Thanks > Glen Ogilvie > New Zealand > > > -- > Glen Ogilvie > New Zealand > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >