Archives of the TeradataForum
Message Posted: Tue, 21 Feb 2012 @ 09:31:48 GMT
You can try using 'AT' clause to define the Time Zone along with your timestamp partition definition and make you code deterministic, as recommended for TD 13:
Partition BY RANGE_N(Cast(TimStmp_data As DATE AT LOCAL) --Can also use hard coded time zone ex. '05:30' Between DATE '2011-01-01' AND Date '2011-01-01' Each Interval '1' MONTH )
Hope this should help.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|