title: how to create a timestamp with only date in mysql?
body: <p>I'm trying to create a timestamp with only date.
  this is what I get to work.</p>
  
  <pre><code>create table verses 
  ( 
       id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, 
       username VARCHAR(255), 
       content VARCHAR(1023), 
       time DATE
  );
  
  insert into verses (username, content, time) 
  values ('test', 'blbabblabalbla', CURDATE());
  </code></pre>
  
  <p>this works but I need to insert the time each time. is there any way to do this automatically?
  like similar to when we use TIMESTAMP?
  I did try this but didnt work</p>
  
  <pre><code>create table verses 
  ( 
     id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, 
     username VARCHAR(255), 
     content VARCHAR(1023), 
     time CURDATE(TIMESTAMP)
  );
  </code></pre>