short_text looks to me as the best alternative. As long as you allways use 4 digits (09:00) it will even sort right
or use the unix time thing and use a long number to store the number of seconds sinds 1/1/1970 or something.
If you want to store date and time, and keep it a bit human readable, I would use a sting or number containing "YYYYMMDDhhmmss" (it now is 20051123114925) In that form you can sort it, but can't do any calculations with it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.