Mysql Get Date Current Date

UploadFile/rohatash/higher-and-lower-precision-system-date-and-time-functions-in/Images/Month-Function-in-Sql-Server.jpg' alt='Mysql Get Date Current Date' title='Mysql Get Date Current Date' />CURRENTDATECURDATE not working as default DATE value. As the other answer correctly notes, you cannot use dynamic functions as a default value. You could use TIMESTAMP with the CURRENTTIMESTAMP attribute, but this is not always possible, for example if you want to keep both a creation and updated timestamp, and youd need the only allowed TIMESTAMP column for the second. Land Rover Sat Nav Installation Software'>Land Rover Sat Nav Installation Software. In this case, use a trigger instead. Horse Handicapping Software Ratings. Digitizer Jr Software. Convert milliseconds to date UNIX timestamp UTC time. UkpUb.jpg' alt='Mysql Get Date Current Date' title='Mysql Get Date Current Date' />Pretty straight forward question here, I think this should work but it doesnt. Why doesnt it CREATE TABLE INVOICE INVOICEDATE DATE NOT NULL DEFAULT CURRENTDATE.