Archives of the TeradataForum
Message Posted: Mon, 21 Jan 2013 @ 16:52:58 GMT
Koushik Chandra wrote:
I doubt there's a need to substring a DATE, it's usually more efficient to use EXTRACT, etc.
Could you show what you actually do?
Your system default is set to 'yy/mm/dd' (Integerdate) and the FORMAT is apparently not carried over to the Volatile Table.
Changing the dateform on session level should work:
SET SESSION DATEFORM = ANSIDATE;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|