Greetings!
I am trying to write a simple applicaton in C# that will remove all data older
than 30 days from an SQLite table. However, my application is removing all
data, not just the old data.
Before I run my query, the value_timestamp field of my table contains:
2009-05-07 17:00:43
My query is:
delete from trend_data where datetime(value_timestamp) < '4/7/2009 12:37:32 PM'
I'm sure I'm running into the fact that SQLite allows a user to store any type
of data in any field. So, SQLite has to decide whether to convert the left
side to a string or the right side to a datetime. It appears that it is
choosing to convert the left side. And, going by what I saw in SQLiteSpy, the
first character of the conversion is '2', which is less than '4', so this row
is deleted.
Do I merely have to use the datetime() method on the right side as well?
delete from trend_data where datetime(value_timestamp) < datetime('4/7/2009
12:37:32 PM')
Or is there something else I should be doing?
Thanks very much!
RobR
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
