0 - 2 of 2 tags for cast string as time

Hi,
This is my first post in this forum. I am new to teradata DB. There is a project that I am working on where we are receiving the date in varchar format :
YYYY-MM-DD HH:MI:SS NNNNNNĀ 

I have a table which has a date field and a text field which along with some other information includes the time information in the 'hh:mi:ss' format.

I want to convert this substring to time and then add it to the date field (cast as timestamp) to get a timestamp column.