StringToTimestamp convert

techsavy · Post by **techsavy** » Thu May 28, 2015 11:45 pm

Hi everyone,

Just want to clear my concept on implicit vs explicit conversion of string to timestamp.

If my input is varchar and output is timestamp, shall I need to explicit convert through StringToTimestamp()? I hope datastage convert this implicity.

Which one is better? whether let datastage do implicit conversion or use explicit convert function.

Please suggest

ray.wurlod · Post by **ray.wurlod** » Fri May 29, 2015 1:13 am

You will use explicit conversion, because there is no implicit conversion of string to timestamp.

techsavy · Post by **techsavy** » Fri May 29, 2015 1:27 am

Ray, but if we dont explict cast it and let it varchar till load stage, it wont show any error/warning.

ray.wurlod · Post by **ray.wurlod** » Fri May 29, 2015 3:59 pm

It will when your string isn't a valid timestamp.