B4J Question SQLITE dates

@powerino yourself and other B4X developers need to also use Google for simple questions like this one. I read your first post and thought to myself, you can't find the answer on the forum from yesterday. I did a quick 1 minute Google search and the second or third result gave me the response the you put in your last post by using 'strftime' quick I've never come across before. I see that you have the answer now, but you would have gotten the answer yesterday if you would have done a quick Google search yourself.

aeric said:

As for me, I store both.

Click to expand...

"You" (we) need to be able to handle both, because not always you are the creator of the DB.

LucaMs said:

Did you tried what Log(DateTime.Now) shows? It is a Long.
https://www.b4x.com/guides/B4xSQLiteDatabase/?page=1
https://www.b4x.com/guides/B4xSQLiteDatabase/?page=15
https://www.sqlitetutorial.net/sqlite-date/

Click to expand...

Also make sure check on page 16 too
https://www.b4x.com/guides/B4xSQLiteDatabase/?page=16

LucaMs said:

"You" (we) need to be able to handle both, because not always you are the creator of the DB.

Click to expand...

Ya, we can do whatever we want to our DB.

You must never stop learning and you must always know as much as possible!