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
