[sqlite] Time functions

[Jake Skinner]

I am have declared a column in a table as 'text'. I am storing times as 
strings in this column in the format "HH:MM". I have "09:00" as a time - 
meant to be representing 9 AM. I would like to retrieve the hour, which 
I attempt with "hour(time_col_name)", what is returned is "21" - I am 
expecting "9"

I have tried three different SQLite browsers (sqliteCC, SQLiteDBBrowser 
and sqliteplus) to check my sql. All three of these return "21".

In func.c, 'getDigits' returns the expected value. ie val = 9, so how 
does it get changed to 21?

Thanks
Jake
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]