Hi
I have a problem while i convert to string to Time.
my source is Flat file(fixed width) and need to load data into table(teradata)
The data for Time column from File is like
10:21:15
09:06:58
12:45:06
etc.,
I am generating some random numbers like 000001,123466,001523, etc.,
Now i need to append some random 6 digit numbers as micro seconds and try to load data into table ( column metadata as TIME(6) )
So , i have concatenated as 10:21:15 123456
But while the data is loaded the result in table as showing 10:21:15.000000
Is there any function like stringtotime(incol1,"%hh %mm %ss.s6") or esle anything..stringtotime(incol1,"%hh %mm %ss.s(6)")
I am sure there is no function like above
is i am missing the basics ?
Kindly suggest ..
Thank you
Problem in converting String To TIME with micro seconds
Moderators: chulett, rschirm, roy