Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 09:42:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I think what I would do is create 4 tables with one column each: a timestamp(0), timestamp(6) and then two more of the same type with time zone. Then I would insert a single row. At that point I would use BTEQ to .export data file=xxxx(n).dat.

Then, I would subtract the two byte header and the one byte carriage return and I would have the answer.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>