On 1/23/2012 2:42 PM, Petite Abeille wrote:

On Jan 23, 2012, at 8:39 PM, dotolee wrote:

                print "<td>".date('Y-m-d h:m:s',$row['updated'])."</td></tr>";

%m              month: 01-12
%M              minute: 00-59

Check the fine manual:

http://www.sqlite.org/lang_datefunc.html

Or rather, http://php.net/manual/en/function.date.php , since the OP is using PHP's date() function, not SQLite's. Therefore, the correct format appears to be 'Y-m-d H:i:s'
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to