]]>By: Danielhttp://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/#comment-1729725
Tue, 28 Apr 2015 22:15:53 +0000http://blog.sqlauthority.com/?p=5940#comment-1729725Hi, I’ve tryed to use this but it doesn’t function, it appears a message saying: “Type TIME is not a defined system type.”, also if I use the date, I need to compare with the BETWEEN in hours and it doesn’t function, but if I put the date (for example “BETWEEN ’04/04/2015′ AND ’04/05/2015′ “) the query give a result, but if I use “BETWEEN ’06:00:00.000′ AND ’20:00:00.000′ ” it doesn’t show any result, can anyone help please?

]]>By: karimsultanhttp://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/#comment-1708182
Sun, 29 Mar 2015 13:44:51 +0000http://blog.sqlauthority.com/?p=5940#comment-1708182when I use this command it returns the date , and the time of the time i run the query and not the recorded date and time in the date time field in the table?!

]]>By: Vasihttp://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/#comment-570116
Fri, 23 Aug 2013 22:22:41 +0000http://blog.sqlauthority.com/?p=5940#comment-570116Hey, I am looking for sql statement to get number of minutes till to date in that year. Any help?