Default value in database not populating

Question

Hi there, 
 
 I have created a table in the DB with a default value of current timestamp for a dateTime column. However when i try to write to it using a CDT the default column is null. 
 Table structure.

CDT definition.

Any help would be appreciated

Mike Schmitt · Answer

AFAIK the "default value" for a column (when we're talking about the SQL table definition) only applies when adding that column to an existing table with existing entries - and perhaps some other aspects of directly adding new rows to the table directly via SQL commands and/or in the PHPMyAdmin interface - but it has no bearing on what happens when you create new rows in a process (nor does Appian have any insight into what the SQL "default" setting is set to). 
 Long story short: you'll need to manually populate that value when creating rows in Appian, as always.