On 2 November 2012 13:08, Григорий Григоренко <grigore...@mail.ru> wrote: > > Thu, 1 Nov 2012 19:57:42 +0000 от Simon Slavin <slav...@bigfraud.org>: > >> > Please read >> >> > <http://www.sqlite.org/lang_datefunc.html> >> > Surely, I did) Don't get me wrong - my point is not that Sqlite is lacking > functions that modify or format date values. > > It's about having useful shortcut for getting current moment that doesn't > have (string) parameters and so can be easily remembered and typed. > > Compare: > MS SQL: CURRENT_TIMESTAMP > PostgreSQL: now() > Oracle: sysdate > > To: > Sqlite: strftime('%s','now')
datetime() will give current date and time likewise date(), time() etc Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users