title: What should be the datatype of a sql table's column if we are inserting `NOW()` in the column
body: <p>I am trying to recreate the database that a particular java codebase works with locally. Here is a piece of sql statement I found in the codebase</p>
  
  <pre><code>sql="Insert into work(comid,alloc,type,priority,m1,m2,m3,m4,m5,m6,r1,r2,r3,r4,r5,r6"
                  + ",w,start,days) values("+comid+','+0+','+type+','+pri+','+m1+','+m2+','+m3+','+m4+','+m5+','+m6
                  +','+r1+','+r2+','+r3+','+r4+','+r5+','+r6+','+w+','+"NOW()"+','+da+')';
  </code></pre>
  
  <p>I want to know if I want to create the <code>work</code> table locally what should be the datatype of the <code>start</code> column should it be varchar or some other special date type?</p>