title: Does Teradata support literals for DATE and TIMESTAMP?
body: <p>I'd like to be able to do something like this:</p>
  
  <p><code>insert into mydb.mytable (updatetimestamp) values (#1/15/2012 01:03:00#)</code></p>
  
  <p>...or...</p>
  
  <p><code>select * from mydb.mytable where updatetimestamp = #1/15/2012 01:03:00#</code></p>
  
  <p>Using literals wouldn't required the longwindedness of casting and whatnot since it would immediately interpret the expression as a DATE or TIMESTAMP.</p>
  
  <p>Does Teradata support this type of syntax?</p>