Re: [sqlite] how to compare time stamp

2011-09-13 Thread Brad Stiles
>        • TEXT as ISO8601 strings ("-MM-DD HH:MM:SS.SSS"). I personally have had the best luck with this storage mechanism. I'm lazy, and my platforms all understand this format readily, and it has the advantage of being human readable as well. ___

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Petite Abeille
On Sep 13, 2011, at 8:18 AM, Akash Agrawal wrote: > I have table in which i have column of Date contain both *date and > time* Well, considering that SQLite doesn't have any "date and time" data type it's hard to tell... To quote the fine manual: SQLite does not have a storage class set aside

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Igor Tandetnik
Akash Agrawal wrote: > I have table in which i have column of Date contain both *date and > time*when compare the value in my c++ program it is not giving me > correct > result . can you help to solve my problem. Show how you are inserting the data into the table, and how you are retrieving it.

Re: [sqlite] how to compare time stamp

2011-09-13 Thread Steffen Mangold
Akash Agrawal wrotes: > > I have table in which i have column of Date contain both *date and time*when > compare the value in my c++ program it is not giving me correct result . can > you help to solve my problem. > Hi, I had a similar problem. How accurate is your time? I had such a problem wi

[sqlite] how to compare time stamp

2011-09-12 Thread Akash Agrawal
Hi, I have table in which i have column of Date contain both *date and time*when compare the value in my c++ program it is not giving me correct result . can you help to solve my problem. -- Thank you Akash Agrawal ___ sqlite-users mailing list sqlite