Re: [PHP-DB] newbie needs to format time field

2001-09-05 Thread Eric J Schwinder
thanks so much, I've gotten a lot from that page of the mySQL documentation... but I'm still needing little more help. I am currently using the following PHP to generate my page (with results displayed in standard mySQL date and time formats): $db = mysql_connect(localhost, username,

Re: [PHP-DB] newbie needs to format time field

2001-09-05 Thread Paul Burney
on 9/5/01 9:22 PM, Eric J Schwinder at [EMAIL PROTECTED] wrote: thanks so much, I've gotten a lot from that page of the mySQL documentation... Here's another one for you: http://www.mysql.com/doc/S/E/SELECT.html quote A SELECT expression may be given an alias using AS. /quote So instead

[PHP-DB] newbie needs to format time field

2001-09-03 Thread Eric J Schwinder
This may be a dumb question but here goes: I have a mySQL database that I am using PHP to interface with. I have fields in the database that are DATE and TIME types. Can I format these values so that the user sees September 15, 2001 or 2:00 PM instead of 2001-09-15 and 14:00:00 when I show

SV: [PHP-DB] newbie needs to format time field

2001-09-03 Thread Torgil Zechel
] newbie needs to format time field This may be a dumb question but here goes: I have a mySQL database that I am using PHP to interface with. I have fields in the database that are DATE and TIME types. Can I format these values so that the user sees September 15, 2001 or 2:00 PM instead