> but is returning the value stored in the database when executed > as a part of a java program. Can anyone help me if I am missing > something here ?
Looks like your java program runs with a different locale than SQLite Manager. I'm not sure why it thinks that you are in a UTC timezone. Maybe there's something in starting scripts or in initialization code of this program? Pavel On Thu, Jun 2, 2011 at 7:32 AM, Sridhar Polavarapu <sridhar.polavar...@idc-rimage.com> wrote: > Hi > > I am preparing a string sql query as follows > > String jobQuery = "SELECT j.jobId, c.channelName , > datetime(j.jobCreateDate,'localtime') as jobCreateDate, j.jobStatus, > CASE WHEN j.jobQuality='md' THEN 'Medium' WHEN j.jobQuality='hi' THEN > 'High' WHEN j.jobQuality='lo' THEN 'Low' ELSE 'Unspecified' END AS > jobQuality, j.jobCompleteDate "; > jobQuery += "FROM Job j "; > jobQuery += "JOIN Channel c ON c.channelId = j.jobChannelId "; > > this query gives me jobCreateDate in my localtime when run in sqlite > manager, but is returning the value stored in the database when executed > as a part of a java program. Can anyone help me if I am missing > something here ? > > Sridhar > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users