Select query involving comparison between dates and time

Select query involving comparison between dates and time

References

Reference NO 1

http://stackoverflow.com/questions/15201134/select-query-involving-comparison-between-dates-and-time

Reference NO 2

http://www.bigresource.com/VB-sql-select-statement-syntax-involving-date-time--Tv3sKHGVww.html

Reference NO 3

http://dba.stackexchange.com/questions/41989/how-to-ensure-that-date-range-queries-involving-multiple-time-zones-are-sargable

Reference NO 4

http://www.sqlservercentral.com/articles/T-SQL/65806/

Reference NO 5

http://use-the-index-luke.com/sql/where-clause/obfuscation/dates

Reference NO 6

http://www.bennadel.com/blog/192-SQL-Date-Time-BETWEEN-And-Comparison-Operators-Work-With-Floats.htm

Reference NO 7

http://www.projectwoman.com/articles/07Access.htm

Reference NO 8

http://en.wikipedia.org/wiki/SQL