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
>
> > 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 table_name;
> > to format my time column, But it didn't work.
>
>
> Try entering the column_name without the quotation marks.
> The column has been declared as an appropriate type and filled with data,
hasn't it?
>
> =dn
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.319 / Virus Database: 178 - Release Date: 1/28/02
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
