Re: [sqlite] Ticks to unixepoch date

Hi Roberto, Re: Please find a test database in the attachment. I don't think attachments are permitted on the mailing list messages. If it's only ten rows, perhaps just using the command line utility to perform a .dump Command and pasting the text into a new message would do the trick.

Re: [sqlite] Ticks to unixepoch date

Thanks for your answer. Please find a test database in the attachment. As you can see I have 1 table with 10 records, and the columns StartDate and EndDate represent a DateTime field, where the values are saved as ticks. There is a view that tries to convert the ticks into unixepoch values, but

Re: [sqlite] Ticks to unixepoch date

Systems From: sqlite-users-boun...@sqlite.org on behalf of Roberto Dalmonte Sent: Tue 7/13/2010 10:20 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] Ticks to unixepoch date Thanks for pointing that out Israel. I had the right value

Re: [sqlite] Ticks to unixepoch date

Thanks for pointing that out Israel. I had the right value (-62135596800) but I mistakenly pasted something else. Nonetheless I get the following error: invalid floating point operation Any idea to make that statement work? Best Regards Roberto Dalmonte Il 13/07/2010 16:46, Israel Lins

Re: [sqlite] Ticks to unixepoch date

Let me understand you... if tick is 0 the date id 0001/01/01 12:00:00? if yes the select do you want is SELECT datetime((TICK_VALUE / 100) - 62135553600, 'unixepoch') AS Expr1 use that site for help! http://www.epochconverter.com/ - "Roberto Dalmonte"

[sqlite] Ticks to unixepoch date

In theory it should be possible to do it right now using the following syntax ... SELECTdatetime((columnAsTicks / 100) - 186796800, 'unixepoch') AS Expr1 FROMTable ...unfortunately it doesn't work, at least the way I tried it. The operation is the following: 1)