Sorting on fieldtype Time?

I have a small problem.. I need to sort some rows on a Time field, but
the time in these rows are recorded on evenings and nights, from 2200 to
0600 for instance. The problem is that the time after midnight should
come after the time before midnight, i.e. 2315, 2345, 0015, 0100 should
be sorted in this order and not 0015, 0100, 2315,2345.
Is there a solution to this, other than using Timestamp instead of Time?


Regards,

BTJ



-----------------------------------------------------------------------------------------------
Bjørn T Johansen (BSc,MNIF)
Executive Manager
btj@havleik.no                  Havleik Consulting
Phone : +47 67 54 15 17         Conradisvei 4
Fax : +47 67 54 13 91           N-1338 Sandvika
Cellular : +47 926 93 298       http://www.havleik.no
-----------------------------------------------------------------------------------------------
"The stickers on the side of the box said "Supported Platforms: Windows
98, Windows NT 4.0,
Windows 2000 or better", so clearly Linux was a supported platform."
-----------------------------------------------------------------------------------------------