What format does the apple notes sqlite db date use?
Solution 1:
According to this answer on Stack Overflow, it's a Unix timestamp adjusted by 31 years. This is typical of CoreData, Apple's ORM framework. The following would work:
select datetime(zmodificationdate,'unixepoch','31 years') from znote