I have verified my locale and default time zone in the same program.The values are correct and it is not UTC timezone. Any help appreciated.
Sridhar On 02-06-2011 19:34, Sridhar Polavarapu wrote: > The returned value is displayed to the user. We are not storing back > the returned column. > > Sridhar > > On 02-06-2011 19:28, Pavel Ivanov wrote: >>> 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 >> <[email protected]> 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 >>> [email protected] >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
