search date on DB by using timestamp

search date on DB by using timestamp

References

Reference NO 1

http://stackoverflow.com/questions/15190500/search-date-on-db-by-using-timestamp

Reference NO 2

http://stackoverflow.com/questions/409286/datetime-vs-timestamp

Reference NO 3

http://www.webdeveloper.com/forum/showthread.php?234645-how-to-search-timestamp-using-date-in-mysql

Reference NO 4

http://www.analysisandsolutions.com/code/dates.htm

Reference NO 5

http://dba.stackexchange.com/questions/16036/compare-a-date-and-a-timestamp-with-time-zone-with-now-in-the-same-query

Reference NO 6

http://www.dbforums.com/db2/1678267-slow-search-timestamp-date.html

Reference NO 7

http://ellislab.com/forums/viewreply/652458/

Reference NO 8

http://forums.teradata.com/forum/database/need-to-convert-a-timestamp-column-value-to-simple-date-format