Error
Error message
PDOException: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type timestamp: "finance-01-01 00:00:00"
LINE 7: ...eld_published_date0.field_published_date_value >= 'finance-0...
^: SELECT field_data_field_published_date0.entity_type AS entity_type, field_data_field_published_date0.entity_id AS entity_id, field_data_field_published_date0.revision_id AS revision_id, field_data_field_published_date0.bundle AS bundle, field_data_field_published_date2.field_published_date_value AS field_data_field_published_date2field_published_date_value
FROM
{field_data_field_published_date} field_data_field_published_date0
INNER JOIN {field_data_field_published_date} field_data_field_published_date1 ON field_data_field_published_date1.entity_type = field_data_field_published_date0.entity_type AND field_data_field_published_date1.entity_id = field_data_field_published_date0.entity_id
INNER JOIN {field_data_field_published_date} field_data_field_published_date2 ON field_data_field_published_date2.entity_type = field_data_field_published_date0.entity_type AND field_data_field_published_date2.entity_id = field_data_field_published_date0.entity_id
INNER JOIN {node} node ON node.nid = field_data_field_published_date0.entity_id
WHERE (field_data_field_published_date0.field_published_date_value >= :db_condition_placeholder_0) AND (field_data_field_published_date1.field_published_date_value <= :db_condition_placeholder_1) AND (field_data_field_published_date0.deleted = :db_condition_placeholder_2) AND (node.status = :db_condition_placeholder_3) AND (field_data_field_published_date0.entity_type = :db_condition_placeholder_4) AND (field_data_field_published_date0.bundle = :db_condition_placeholder_5)
ORDER BY field_data_field_published_date2.field_published_date_value DESC; Array
(
[:db_condition_placeholder_0] => finance-01-01 00:00:00
[:db_condition_placeholder_1] => finance-12-31 23:59:59
[:db_condition_placeholder_2] => 0
[:db_condition_placeholder_3] => 1
[:db_condition_placeholder_4] => node
[:db_condition_placeholder_5] => magazine
)
in field_sql_storage_field_storage_query() (line 760 of /var/app/current/modules/field/modules/field_sql_storage/field_sql_storage.module). The website encountered an unexpected error. Please try again later.