Re: [PHP-DB] date, and time?

2003-07-10 Thread jeffrey_n_Dyke
you could change mysql to a few different date formats, but i don't _think_ that is one of them. Why not just take care of a format change on the way out with DATE_FORMAT. Also, if you store the date as one of the defualt date[time] values then you have tons of functions that you can run against

Re: [PHP-DB] Date and time issues

2002-11-04 Thread Peter Beckman
I assume you are trying to insert into a mysql table column that is a date. insert into table (datecol) values (from_unixtime($new_exp_day)); Example output of from_unixtime: +---+ | from_unixtime(10) | +---+ | 2001-09-08 21:46:40 |

Re: [PHP-DB] Date and time issues

2002-11-04 Thread Ignatius Reilly
If you are using MySQL, you may profitably investigate the function DATE_ADD( date, INTERVAL ) Ignatius J. Reilly - Original Message - From: Frederik Feys [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 10:32 PM Subject: