HOW TO RETRIEVE THE TIME USING SQL STATEMENT
Posted on 2004-09-02
can i retrieve only the 'time' from the datetime?
A datetime like '2004-09-02 13:42:002', i want to take out only the time '13:42:002'
is it possible to do this?
and some more i want to find out the difference between two date/datetime.
It can be done using DATEDIFF in SQL but it only give me the result in either hour or minute or second or m. Second.
I want to result to be something like this :-
The Difference between this two date is 1 hour 30 minutes 39 second OR 1:30:39