In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> In general, is it better to have MySQL select less using TIME_FORMAT than=20
> to have PHP crop the info?
>
> -Lisi
The general rule of thumb seems to be: if mysql can do it, use mysql else
use php.
--
Quod subigo farinam
$email =~
In general, is it better to have MySQL select less using TIME_FORMAT than
to have PHP crop the info?
-Lisi
At 09:50 PM 6/17/03 -0400, John W. Holmes wrote:
Lisi wrote:
If I have a time stored in MySQL, and I only need the hour and minutes
without seconds:
1) Can I crop this in PHP after retriev
Lisi wrote:
If I have a time stored in MySQL, and I only need the hour and minutes
without seconds:
1) Can I crop this in PHP after retrieving it?
Sure, just chop off the last : and what's after it if in HH:MM:SS
format, or the last two numbers if in HHMMSS format.
2) Is there a way to store th
Check the TIME_FORMAT(time,format) MySQL function.
Ignatius
_
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 1:16 PM
Subject: [PHP-DB] time without seconds
&g
If I have a time stored in MySQL, and I only need the hour and minutes
without seconds:
1) Can I crop this in PHP after retrieving it?
2) Is there a way to store this without the seconds in MySQL?
Same goes for storing a date without the year. I could use a regular char
field, but I want to be