querying with the datetime type

[Soham Sardar]

i have a problem with querying with the datetime format of mysql and
then it has to stored in the string format and nothing else and then
when i try to query in it say name the users who logged between 10 to
11 am in time coz i am using  LIKE which matches pattern and then i
cant give like for all the time instances ... can some one help me out
with this as to how to implement these types of querying both in HIVE
and mySql