title: Postgresql: How can we insert only time and date into a variable using timestamp?
body: <p>Error: Getting an error near time format while inserting.  </p>
  
  <p>Example:  </p>
  
  <pre><code>--Table "Test"  
  
  create table test  
  (  
  name varchar(10),  
  date1 timestamp,  
  time1 timestamp  
  );  
  
  -- Insertion  
  insert into test values('xyz','03/03/2014','02:03:04');  
  </code></pre>