Activity overview
Latest activity by SQLHatGuy
It looks like SQLPrompt is using LDAP/AD/NT timestamp format which is the number of 100ms ticks since 1/1/1601. Based on this I came up with this SQL which is working for me so far (more testing needed): SELECT datetime('1601-01-01', (qv.DateSaved / 10000000)||' seconds') ,* FROM QueryVersions qv / comments
It looks like SQLPrompt is using LDAP/AD/NT timestamp format which is the number of 100ms ticks since 1/1/1601. Based on this I came up with this SQL which is working for me so far (more testing n...