title: SQlite creating a database with a timestamp column and adding a value in
body: <p>I am trying to create a database that called rawData. The db will hava a column for the id, a foreign user id (_id from another table), data and finally a timestamp.</p>
  
  <p>My question is how can I create a timestamp in SQlite and store it in the db also what type should the column be, text? the database needs to be able to store 150 float values a second and time stamp each of those 150 entries. Additionally since SQlite doesn't have a float type should i use real as the column type?</p>
  
  <pre><code>public class RawDatabase{
  public static final String TABLE_RAW_DATA = "rawData";
  public static final String COLUMN_ID = "_id";
  public static final String COLUMN_FOREIGN_USER_ID = "foreignUserId";
  public static final String COLUMN_DATA = "data";
  public static final String COLUMN_TIME_STAMP = "timeStamp";
  
  // Database creation sql statement
  private static final String DATABASE_CREATE = "create table "
      + TABLE_RAW_DATA + "(" + COLUMN_ID
      + " integer primary key autoincrement, " + COLUMN_FOREIGN_USER_ID
      + " integer, " + COLUMN_DATA 
      + " real, " + COLUMN_TIME_STAMP
      + " text not null);";
  }
  </code></pre>