Hello Anuradha
Let's go ahead...
First, output the result to a txt file, then use tMysqlBulkExec instead of tMysqlOutputBulkExec to run the txt file. See my screenshot.
in.csv:
1;2009-02-26 01:02:33
2;
3;2009-02-27 01:02:33
expression of date column:
(row1.date.equals("")?"\"\\N\"":row1.date)
Best regards
shong