I am trying to perform a date comparison.Following is the scenario.I am getting a response from web request in XML format and from that I am parsing a date value as
"2014-07-15T09:23:08.378Z"(EST format).Now I am saving this into SQLite database using query
INSERT INTO table_name (dateValue) VALUES(DATETIME(?))",modifiedDate]
Later when trying to retrieve this save date value ,I am getting the result in the format "2014-07-02 09:23:08"(which is in DATETIME format from sqlite).Now I need to compare these two date formats (i.e "2014-07-15T09:23:08.378Z" and "2014-07-02 09:23:08").Please help me on this.Looking forward for a solution