Igor,
Thank you very much for your reply.
So, since SQLite doesn't have a dedicated date or time type, what does the
datetime() function return? Merely a string in a guaranteed format? I'm sure
I need to use the datetime() function on both sides of the comparison to ensure
that I'm comparing apples to apples. I also changed the format of the string
my application generates. The query is now:
delete from trend_data where datetime(value_timestamp) < datetime('2009-04-07
12:37:32')
It seems to be working.
But, just for my eduction, does the string in the call to the datetime()
function have to formatted in the way I have it here? In SQLiteSpy, I tried
"select datetime('04-07-2009 12:37:32')" and "select datetime('2009/04/07
12:37:32')". Both of them returned nothing.
Thanks again!
RobR
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
