On 21 Aug 2009, at 7:25pm, t-master wrote: > I have string in a table representing a DateTime. > The format is 21.08.2009 00:25:00 > And I would like to compare it to "now" > How can I do this?
If you need to know whether it's before or after instead of just equal, then you're going to need to hold the components of the date/ time in a more useful order: one in which a normal string sorting method will tell which is first. In other words, the year must be first, not buried in the middle somewhere. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
