I am using the to_data function, my first error was clear to me as it didn't like 0000-00-00 00:00:00 I managed that with a where clause, but this one baffles me:
SYSTEM ERROR: IllegalInstantException: Cannot parse "2003-04-06 02:34:20": Illegal instant due to time zone offset transition (America/Chicago) Fragment 3:9 Looking at that date, it doesn't look like an illegal moment in time, it's not near a leap year or anything funny like that. The query I am running is: select to_date(createdon, 'yyyy-MM-dd HH:mm:ss'), count(*) as num_creates from view_myrecs where createdon <> '0000-00-00 00:00:00' group by to_date(createdon, 'yyyy-MM-dd HH:mm:ss')
