http://shinephp.com/community/tags/extjs-grid General Web development, PHP, MySQL, WordPress and its plugins discussions en-US Thu, 09 Feb 2012 04:25:35 +0000 http://bbpress.org/?v=1.0.2 q http://shinephp.com/community/search.php http://shinephp.com/community/topic/extjs-grid-doesnt-show-the-date-field-value#post-4 Tue, 23 Feb 2010 06:04:31 +0000 vladimir 4@http://shinephp.com/community/ <p>One of the reason can be the different Date and Time format which you use in MySQL select expression and ExtJS script.<br /> For example MySQL returns datetime field value as 'YYYY-mm-dd hh:mm:ss' by default.<br /> If you have</p> <div class="bb_syntax"><div class="code"><pre class="javascript" style="font-family:monospace;">format<span style="color: #339933;">:</span> <span style="color: #3366CC;">'m-d-Y H:i:s'</span></pre></div></div> <p>in your datetime grid column definition, you will see the blanks instead of real date and time values.<br /> So to resolve this problem you can use the same datetime format at your MySQL select expression, e.g.</p> <div class="bb_syntax"><div class="code"><pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> DATE_FORMAT<span style="color: #66cc66;">&#40;</span>datetimefield<span style="color: #66cc66;">,</span> <span style="color: #ff0000;">'%m-%d-%Y %H:%i:%s'</span><span style="color: #66cc66;">&#41;</span> <span style="color: #993333; font-weight: bold;">AS</span> datetimefield <span style="color: #993333; font-weight: bold;">FROM</span> sometable</pre></div></div> http://shinephp.com/community/topic/extjs-grid-doesnt-show-the-date-field-value#post-3 Tue, 23 Feb 2010 05:49:08 +0000 garvs 3@http://shinephp.com/community/ <p>Why ExtJS grid doesn't show the date field value?<br /> I select it from MySQL database and FireBug shows that script receives it, but I see the empty date column in the grid. </p>