What I have learned about DateTime
- By aeric
What are you using B4X for? What have you learnt along the way?
I am developing a POS with B4X using SQLite as the local database for the clients. I thought I am very experience in dealing with SQL and databases. I am very wrong!
In the past, I always store date and time data in table column as String in this format yyyy-MM-dd HH:mm:ss. It always work well. In some databases, we have datetime type of fields.
BUT, SQLite is a very simple database engine...