Sqlite (Max Value)

[jashimu]

Hi all, I am trying to get the largest number from a column. where it happend to be the same number exist multiple times. But I am only interested only one number that is largest. do not care how many are there. thanks FYI database sqlite3. Second question: How come variable type datetime does not work in sqlite. I am using now as string data type but I need to use as datetime where I can query as datetime. thanks again.

[loyal ginger]

select max([your field name]) from [your table]; That returns the max number of that column. There is no DateTime type in SQLite. You can use text type for it. SQLite has a few date/time functions you can use, though. Use ANSI format for the datetime field. It will sort the field correctly.

[jashimu]

Thanks for your reply. I will let you know if were able to solve my problems. thanks again.

[jashimu]

Loyal ginger, thanks for your help it works. Just to let you know that I am very new to database. thanks

[dan sh]

So why not vote the reply as good answer.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Mycroft Holmes]

loyal ginger wrote:

There is no DateTime type in SQLite

I find that incredible considering all the problems that arise from storing date values as strings.

Never underestimate the power of human stupidity RAH