Truncated incorrect date value: '02:02:02 am'
<p>When i insert this time '02:02:02 am' to a mysql time field using the following Query:</p>

<pre><code>insert INTO invoices(name,phone,totalsum,givenmoney,date,time,moreinfo) VALUES ('f','2','2','2','1994-01-01',DATE_FORMAT('02:02:02 am','%h:%i:%s %p'),'AA')
</code></pre>

<p>It shows the following error</p>

<pre><code>Truncated incorrect date value: '02:02:02 am'
</code></pre>

<p>how to solve it?</p>

<p>Not that the datatype of my time field is <code>TIMESTAMP</code></p>