How to configure complex date type columns in Zoho Analytics?

If we have a date column of type:

2014-11-24 22:47:59.123123 +0530

In the import we choose the general format of the date type columns:

The appropriate format is:

yyyy-MM-dd HH:mm:ss.SSSSSS Z