[sqlite] HELP : how to use datetime('column', 'localtime') as a part of sql string

[Sridhar Polavarapu]

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