Archives of the TeradataForum
Message Posted: Mon, 18 Aug 2008 @ 12:48:42 GMT
I am having a query to subtract 30days from current_timestamp(0). Getting error if I written in bellow manner.
Select Current_timestamp(0) - 30 as prunedate From (Select 1) Tmp (ONE);
Any help will be appreciating. Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|