<div>
<div class="content wysiwyg-content">
I am trying to set a column current_yr to show the current year date by default &nbsp;... eg 2015 .<br />
<br />
Attached is an image of the settings I am using. &nbsp;This setting however only results in default 0000 appearing in all rows of the table.<br />
<br />
Can someone give me the correct setting to achieve this ?<br />
<br />
many thanks<br />
<br />
james<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/07_w30/925000/date-problem.jpg" target="_blank" title="Current mysql structure settings (51 KB)"><img alt="Current mysql structure settings" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w30/800_925000/date-problem.jpg" /></a>
</div>
</div>


date-problem.jpg

I am trying to set a column current_yr to show the current year date by default  ... eg 2015 .

Attached is an image of the settings I am using.  This setting however only results in default 0000 appearing in all rows of the table.

Can someone give me the correct setting to achieve this ?

many thanks

james



Setting YEAR in MYSQL table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.