Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2011 @ 17:29:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Another method that is fun, but not very intuitive is this:

     select current_date (format 'EEEE') (char(9)) as "long format"
     ,  current_date (format 'EEE') (char(3)) as "short format"
     ;

Returns:

     long format   short format
     Thursday      Thu

Paul Burns

	<Prev	Next>		<<First	<Prev	Next>	Last>>