android - TimeStamp Difference Between Java and SQLite -

hello have , slqlite database in have table water_logs

create table water_logs(  _id integer primary key autoincrement, amount real not null, icon integer not null, date integer not null); 

i store date in milliseconds.

calendar cal = calendar.getinstance();  cal.gettimeinmillis(); 

my problem want day date column using strftime function. problem tjat java calendar timestamp different slqlite time stamp

1436859563832 --> result cal.gettimeinmillis();  1436607407--> select strftime('%s','now') 

what i'm trying group records day. following sql query works fine if value of select strftime('%s','now') paste in date column

select sum(amount), date(`date`) water_logs group date(`date`, 'unixepoch') 

seems me using 2 different value types.

when use

calendar cal = calendar.getinstance();  long time = cal.gettimeinmillis(); 

the output value in milliseconds, described here.

while when use

strftime('%s','now') 

the output value in seconds, described here.

so, might cause mismatch between 2 values. of course value in seconds might undergo rounding might change value little.