Java tutorial
//package com.java2s; import java.util.Date; public class Main { /** * takes a sqlite unix style representation and convert to java Date */ public static Date sqlite2javaDate(String sqliteDate) { return new Date(Long.parseLong(sqliteDate) * 1000L); // return "(strftime('%s', "+fieldName+", 'unixepoch') * 1000) AS "+fieldName; } }