All Forums UDA
roy_soumya 3 posts Joined 04/09
23 Apr 2009
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

You must sign in to leave a comment.