MySQL Time function date_format

http://toptree.iteye.com/blog/812642 today, in the development of the mail system to find a lot of mail is not sent successfully, want to manually change the data. Find the MySQL date function

The obtained pubtime is a string type, which is converted in the SQL statement using the MySQL time function date_format (' Times ', ' format '):

String sqlstr= "SELECT * from Do_document where

Pub_time<date_format (' +pubtime+ ', '%y-%m-%d%h:%i:%s ') Order BY pub_time desc limit 0,1 ";

The SQL statement is then executed to find the record that satisfies the condition.

Usage:

　　Select COUNT (*) from MESSAGE where Date_format (sendtime, '%y-%m-%d ') = ' 2010-11-16 '

SELECT COUNT (*) from test_table where ActivityID in ( -1,4) and Weibotime < Str_to_date (' 2011-09-01 00:00:00 ', '% y-%m-%d%h:%i:%s ')

MySQL Time function date_format