How to get the day's record

Category: Web Develop
 
heisedenvren
2013-08-20 03:15:12

Sponsored Links
There are several fields in a table
; id, title, content, datetime, flag
type are automatically numbered varchar, varchar, smalldatetime, bit
This field is required datetime detected through all the records that day. Will the use of how to write SQL statements.

Sponsored Links

LIUBIN_TIANJIN
2013-08-20 03:25:54
select * from table where convert (char (10), [datetime], 120) = convert (char (10), getdate (), 120)
Domain and server ip had changed since 8/23/2013. Suspend the user registration and posts for program maintenance.