Page 1 of 1

TimeStamp Null handling

Posted: Mon Oct 18, 2010 2:41 pm
by highpoint
I have source column as "TimeStamp". I was getting warning
as :

APT_CombinedOperatorController(1),0: Field 'Col1' from input dataset '0' is NULL. Record dropped.


by going through forumn tried using NullToEmpty and StringtoTimestamp function,

Now getting following Warning:

Conversion error calling conversion routine timestamp_from_string data may have been lost.


Appreciate help in resolving this.

Posted: Mon Oct 18, 2010 3:45 pm
by anbu
StringtoTimestamp expects a timestamp string and not an empty string. Use NullToValue or if you want nulls to be passed then dont use StringtoTimestamp on Nulls