To be able to do this you need the following data points: 1. What is the integer representation of the date? Is it days or seconds from a certain date? Keep in mind that 1 day = 86400 seconds = 3600 minutes
Most date representations are stored as seconds since 1-1-1970 depending on the underlying OS 2. Once you have figured out #1 then you need to perform a function to convert that value to a SQLite date which is stored as DD-MM-YYYY (or MM-DD-YYYY). Since you didn't specify the programming language you were using I don't know what function will do this. Assuming that you are using C (or a variant) or Java there are functions that will do this for you. ------Original Message------ From: Nicolás Solá Sender: sqlite-users-boun...@sqlite.org To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite Database Sent: Mar 11, 2009 09:21 Subject: [sqlite] datetime as integer Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB schema there is a table called “milestone”. It has a field called “due” and it means due date. The problem is that it uses an integer data type to store the datum and I don’t know how to show it in a SELECT query as datetime. Can anyone help me please? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: tsaw...@mybowlingdiary.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
