In my table the field of DateTime name is TIN. In this field DATE and TIME are shown for date I pass this query:
[code=sql]SELECT DAY(TIN) FROM SHIFT WHERE SHID = 1[/code]
Then the result is "10".

So the same I want to get Hour fromt his field I pass this query:
[code=sql]SELECT HOUR(TIN) FROM SHIFT WHERE SHID = 1[/code]

But it gives this error:


So please help me...