Sending System Date to Char(26) with Nano Second

UDA

Sending System Date to Char(26) with Nano Second

Hi,

I have a nice problem.
I have to send the system date to a char(26) field with Nano second using Informatica V8.
My database is Teradata.
I am using this logic -- to_char(sysdate,'YYYY-MM-DD-HH24.MI.SS.NS') and the result is 2009-04-23-09.27.16.000000. But I require values in last 6 digits like 2009-04-23-09.27.16.123456.
Could you pls help me.

Thanks & Regards.
Roy