https://community.qlik.com/t5/Talend-Studio/Date-Format-Convert-string-date-to-null/m-p/2324850#M94511 Hi,<BR />I am loading text file data into oracle table. Text file contains date value in string format 'yyyymmdd'.<BR />Loading works fine for valid dates but when text file containg date value as '00000000', it gets converted to '30'Nov-0002' date in Oracle (unknown value).<BR />Could you please help me in formatting '00000000' date string to replace by NULL?<BR />Thanks,<BR />Neil Sat, 16 Nov 2024 12:22:42 GMT _AnonymousUser 2024-11-16T12:22:42Z https://community.qlik.com/t5/Talend-Studio/Date-Format-Convert-string-date-to-null/m-p/2324850#M94511 Hi,<BR />I am loading text file data into oracle table. Text file contains date value in string format 'yyyymmdd'.<BR />Loading works fine for valid dates but when text file containg date value as '00000000', it gets converted to '30'Nov-0002' date in Oracle (unknown value).<BR />Could you please help me in formatting '00000000' date string to replace by NULL?<BR />Thanks,<BR />Neil Sat, 16 Nov 2024 12:22:42 GMT https://community.qlik.com/t5/Talend-Studio/Date-Format-Convert-string-date-to-null/m-p/2324850#M94511 _AnonymousUser 2024-11-16T12:22:42Z https://community.qlik.com/t5/Talend-Studio/Date-Format-Convert-string-date-to-null/m-p/2324851#M94512 Hi Neil<BR />This topic is related to <A href="http://www.talendforge.org/forum/viewtopic.php?pid=78371#p78371" rel="nofollow noopener noreferrer">http://www.talendforge.org/forum/viewtopic.php?pid=78371#p78371</A>.<BR />Regards,<BR />Pedro Wed, 15 Feb 2012 09:26:35 GMT https://community.qlik.com/t5/Talend-Studio/Date-Format-Convert-string-date-to-null/m-p/2324851#M94512 Anonymous 2012-02-15T09:26:35Z