Re: [PHP-DB] MySql, PHP, and Dates

2003-03-30 Thread Bruce Feist
Jason Wong wrote: On Sunday 30 March 2003 11:11, Bruce Feist wrote: I wonder why the PHP/MySql interface doesn't simply return dates as dates instead of strings. *frowns* How do you mean? PHP doesn't have a date type. Ummm That's a good reason! As I said, I'm a newbie to PHP, and somewhere

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-30 Thread Jason Wong
On Sunday 30 March 2003 11:11, Bruce Feist wrote: > I wonder why the PHP/MySql interface doesn't simply return dates as > dates instead of strings. *frowns* How do you mean? PHP doesn't have a date type. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Inte

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-29 Thread Bruce Feist
I originally wrote: when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type > What's the best way of controlling date format? John W. Holmes replied: If you want a Unix timestamp, which is compatible with the date() function in PHP, then use the UNIX_TIMES

RE: [PHP-DB] MySql, PHP, and Dates

2003-03-28 Thread John W. Holmes
> I'm experienced with SQL, but new to MySql and PHP, which I'm using > together to create a dynamic web site. Right now, I'm having minor > difficulties with date formatting. It seems that when I retrieve a date > from MySQL into PHP, it shows up as a string instead of a date data > type, with f