danap wrote: > SELECT CAST((SELECT (julianday('now', 'localtime') - > julianday('1970-01-01'))*24*60*60*1000) AS INTEGER);
Keith wrote: > Are you sure you want to be mixing up timezones? > > julianday('1970-01-01') returns the julianday timestamp > for 1970-01-01 00:00:00 GMT julianday('now', 'localtime') > returns the julianday timestamp for 'now' in your > current timezone. No. You are correct and after my initial posting reply, above, fixed the Time Precision to your initial suggested example, 'now', only in the code. danap. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users