Topic: Differences in the report with equal dates in Julian format
I have the following query in a button Report(SQL):
select
employees.lastname,
employees.firstname,
julianday(dateofbirth, 'localtime') - 2415018.5833333335,
julianday('now', 'localtime') - 2415018.5833333335
from
employees
The value of the DATEOFBIRTH field in the table is the same as that of the variable 'now' but in the report they are different. What is this about?
Thanks