Re: Sorting on fieldtype Time?

On Wed, Jul 09, 2003 at 11:24:14 +0200,
  Bjorn T Johansen <btj@havleik.no> wrote:
> 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?

You could do something like like:

select timecol from timetab order by timecol <= 1200, timecol;