Re: [PHP-DB] mysql time format

2003-01-07 Thread Paul Burney
on 1/6/03 8:24 PM, David Chamberlin at [EMAIL PROTECTED] appended the following bits to my mbox: Is there any way to set the time format so that any time values in my SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS). Basically I've got a table of a variety of

Re: [PHP-DB] mysql time format

2003-01-07 Thread David Chamberlin
Paul Burney wrote: Why not add the TIME_FORMAT calls to the original query rather than performing all the extra queries? Is your first select something like the following? That's what I'd like to do, but not sure how to do that in this context. SELECT

RE: [PHP-DB] mysql time format

2003-01-06 Thread John W. Holmes
This is a bit of a newbie question, but I couldn't find what I wanted in the documentation. Is there any way to set the time format so that any time values in my SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS). Basically I've got a table of a variety of different