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 > <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
