convert Query from SQL to MySQL

See more:

SQL-Server-2005

SQL-Server

MySQL

Please anybody convert the following SQL Query to MySql

select convert(int,datepart(hour,Date_Time),108) as FromHour,convert(int,datepart(hour,Date_Time),108)+1 as ToHour,count(convert(varchar(50),datepart(hour,Date_Time),108)) as counts from tbl_Numbers_Temp where Date_Time>=(select convert(varchar,getdate(),23) as Date)group by convert(int,datepart(hour,Date_Time),108) order by FromHour desc

this above query gives bellow output in SQL,,, now i want this above SQL query convert to MySQL query.

FromHour - ToHour -  counts
11     -      12    -   358

10     -      11    -   55

9      -      10    -   112

8      -      9     -   15

7      -      8     -   856

6      -      7     -   558

5      -      6     -   556

4      -      5     -   458

3      -      4     -   741

2      -      3     -   125

1      -      2     -   789

0      -      1     -   856

Thanks to ALL...