Radcon Entec <radconen...@yahoo.com> wrote: > 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?
Yes. > I'm sure I need to use the datetime() function on both sides > of the comparison Not necessarily, if your timestamps are already in the format that datetime() produces, in which case it's just an expensive no-op. > 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? The documentation at http://sqlite.org/lang_datefunc.html describes all acceptable formats. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users