search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

The TO_DATE function should support entering date in 'yyy-MM-dd' form #567

Open jtaylor-sfdc opened 10 years ago

jtaylor-sfdc commented 10 years ago

The following causes the error below:

  create table foo(x float not null primary key, d date );
  upsert into foo values(1, to_date('1997-11-08'));

java.lang.IllegalStateException: to_date('1997-11-08)' did not match expected date format of 'yyyy-MM-dd HH:mm:ss'.

We should support this.