Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_nam
Hello,
I've been reading about TIME _FORMAT in the mysql manual. Does this only
work
with a manually entered time?
SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
I tried this,
SELECT TIME_FORMAT('column_name','%h:%i') as time FROM
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_nam
Hello,
I've been reading about TIME _FORMAT in the mysql manual. Does this only
work
with a manually entered time?
SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
I tried this,
SELECT TIME_FORMAT('column_name','%h:%i') as time FROM
rested in
> hearing peoples opinions on a fairly trivial subject. I have a feature on
> a page that retrieves times out of a mysql database. I was considering
> formatting the date with javascript, or php, but it would be easiest to
> just format it with the mysql time_format() function. I&#
t would be easiest to just format it
with the mysql time_format() function. I've never used mysql's built in
functions before and I was wondering if I'm going to see any performance
drawbacks from formatting it with mysql instead of passing that off onto
th
