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

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

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

[PHP-DB] MySql, PHP, and Dates

2003-03-28 Thread Bruce Feist
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 format

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