> • 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.
___
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
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.
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
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
5 matches
Mail list logo