Archives of the TeradataForum
Message Posted: Tue, 29 May 2012 @ 16:22:55 GMT
Try the query given below in TeraData SQL Assistant.
Your system will answer you what is difference between DATE FORMAT 'YYDDD' and DATE FORMAT 'YYDD'.
SELECT DATE(FORMAT'DDD')(CHAR(5)) AS DDD, DATE(FORMAT'DD')(CHAR(5)) AS DD
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|