timestamp format
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
timestamp format
i have a timestamp column in a sequencial file with a sample value as "2006-02-25 12:10:22.324555", but i am not getting the 6 decimal in output
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: timestamp format
Are you going into database? Sequential File? What's the data type you are using to read the timestamp (leangth as well)?
I have you tried putting a peek right after the file stage to see if the data is being read by data stage correctly?
I have you tried putting a peek right after the file stage to see if the data is being read by data stage correctly?
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: timestamp format
i am using to read from a seuential file, and after transform insert into teradata table
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Hi Double click you sequential file stage and click the output button and then Columns tab. Inside that right click and select properties inside that you will find Extended column in Position 4
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar