[resolved] how to insert a 0000-00-00 date in a field using talend?

[Anonymous]

Hi
I'm trying to insert a "0000-00-00 " in date' field , bu i don't know how?
any ideas?

Mouad

[Anonymous]

it didn't work,
i get this value instead : 0002-11-30 BC (i'm using postgres database )

[Anonymous · Accepted solution]

Hi,
I think any database doesn't allow "0000-00-00".
Insert "0001-01-01" instead of "0000-00-00" in date filed.
Thanks,
kumar

[Anonymous]

thank brother for your reply,
it did worked
thank u again
i'll set this topic as solved
Regards