timestamp format

keshav0307 · Post by **keshav0307** » Fri Feb 24, 2006 6:23 pm

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

kwwilliams · Post by **kwwilliams** » Fri Feb 24, 2006 6:32 pm

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?

keshav0307 · Post by **keshav0307** » Fri Feb 24, 2006 8:29 pm

i am using to read from a seuential file, and after transform insert into teradata table

sajarman · Post by **sajarman** » Sun Feb 26, 2006 6:50 am

Keshav,

While reading from the sequential file stage, define the particular time stamp column as, SQL Type: "Timestamp" and Extended: "Microseconds" in the output -> columns tab. Give values for length as 26 and scale as 6.
Hope this will solve your problem

.

Best Regards,
Sajarman.

kumar_s · Post by **kumar_s** » Sun Feb 26, 2006 8:10 am

Also check the teradata default timestamp settings.

keshav0307 · Post by **keshav0307** » Mon Feb 27, 2006 5:27 pm

i do not find the "Extended" column property

kumar_s · Post by **kumar_s** » Mon Feb 27, 2006 5:32 pm

keshav0307 wrote:i do not find the "Extended" column property

Right click on the Field properties grid. You can find the list of check option. Extended option might be unchecked.

DSguru2B · Post by **DSguru2B** » Tue Feb 28, 2006 6:51 pm

You should go by the book. :D

rasi · Post by **rasi** » Tue Feb 28, 2006 7:03 pm

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

DSXchange

timestamp format

timestamp format

Re: timestamp format

Re: timestamp format