I only need date, no time is ok, do you have more less memory method?
--- Zanardo <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
