Notessql Timestamp to Varchar

[aahmadfarooq]

Hi,

I have a Notes sql data source. It has a column with Timestamps stored in it some of which are Nulls, Whenever datastage reads a null in select statement against data type Timestamp it gives an error and job fails.
I tried to convert the source into a varchar instead but job still fails on the first ODBC connection where it actually selects the particular row.
The particular data item has '(null)' stored in it, when I try to select nulls this particular row is not selected in DB Visualizer, which means this is not being considered as null.

I couldn't find any function with correct syntax to convert Timestamp into varchar in select statement itself like we can do in normal sql using Cast/Convert.

I found a @Text function which I used as Text(Column_Name) that too failed. Please help!