I only need date, no time is ok, do you have more less memory method? --- Zanardo <zana...@gmail.com> wrote:
> While timestamps (seconds since 1970) need less storage space, I tend > to store dates and times with this format: > > 2010-09-04 09:15:37 > > This is more readable for ad-hoc queries, and you can easily use > range > operations with a simple BETWEEN or a "<=" and ">=". SQLite has a > built-in function to generate this timestamp with the current date > and > time within the current time zone: > > SELECT datetime('now', 'localtime') ; > > Zanardo. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users