Archives of the TeradataForum
Message Posted: Fri, 06 Mar 2009 @ 16:59:36 GMT
As long as you're converting the number to a character, you are right - no calculations. The obvious solution is: DO NOT convert it from a number that you want to a character string which you do not want.
> sel date (format 'ddd')(char(3));
If you are attempting several calculations of this nature in your select, you might want to consider using the view called Sys_calendar.calendar in your query. It has a column names day_of_year.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|