1) Need to store Date and time in either one variable or two.
2) Need to sort the Date and time in ASC and DESC order
3) Need to update the time in just one SQL statement.
4) Only hours and minutes are important while storing the Time
What would be the best way (datatype & format) to store the this kind of data? And what would be the SQL statements to do each of the above requirements?