Re: My SQL TIME_FORMAT

2002-02-12 Thread mike
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

Re: My SQL TIME_FORMAT

2002-02-12 Thread DL Neil
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 ti

Re: My SQL TIME_FORMAT

2002-02-09 Thread mike
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

Re: My SQL TIME_FORMAT

2002-02-09 Thread DL Neil
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 ti