I seem to be having some problems with time. I am storing "17:30" into SQLite. When I do a 'select time(time_col) from table' I am receiving "05:29:59". Being one second out, I can kind of live with but, not returning the correct 24 hour format I can't. I'm sure I'm doing something wrong, however I am completely stumped as to what!
Any ideas?
Cheers Jake
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]