Re: 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?

You can try subtracting a fixed amount to transfer all times
to before midnight and then sort.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346