<div>
syntax is date_format(column_name, 'formatting options')
</div>


syntax is date_format(column_name, 'formatting options')

<div>
Yes, I had used TIME_FORMAT but thanks for making that clear to me.
</div>


Yes, I had used TIME_FORMAT but thanks for making that clear to me.

<div>
<div class="content wysiwyg-content">
I am confused as to how to use the Time type in inserting data in my table. &nbsp;Currently I have Time as the type and 17:00:00 (hours:min:sec) as the way I am entering but am unable to retrieve it as 5:00 PM. <br />
<br />
&nbsp;I have tried DATE_FORMAT(%H, i%) but it does not seem to work. <br />
<br />
&nbsp;The actual syntax was:<br />
Select example.Name, example.DAY, DATE_FORMAT(example.TIME(%<wbr />H,%I))<br />
FROM example<br />
<br />
and <br />
<br />
So I think I am doing everything wrong. &nbsp;Any help would be appreciated.
</div>
</div>


I am confused as to how to use the Time type in inserting data in my table.  Currently I have Time as the type and 17:00:00 (hours:min:sec) as the way I am entering but am unable to retrieve it as 5:00 PM. 

 I have tried DATE_FORMAT(%H, i%) but it does not seem to work. 

 The actual syntax was:
Select example.Name, example.DAY, DATE_FORMAT(example.TIME(%H,%I))
FROM example

and 

So I think I am doing everything wrong.  Any help would be appreciated.

How to use the Time type and retrieve

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.