>How to convert a datetime expression to a character expression?
>How to find the time in a datetime expression?

also:

hour()
minute()
sec()