Problem date error 0000-00-00


I have a problem with date format, when I'm indexing my SQL table, I have
this :
0000-00-00' can not be represented as java.sql.Date

I have tried this for my mapping :

my date = array(
'type' => 'date',

but this did not work !

Can you help me to find an answer ?

Thank you in advance.


You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
For more options, visit