Archives of the TeradataForum

Message Posted: Sat, 01 Mar 2008 @ 11:33:43 GMT

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

Hi ALL,

     sel current_date(format 'mmm');

it only gives first three character of month.

Is there any way in teradata to display full name of month like march,april etc.(By using case,I got it)

But is there any other simplified way to do that.

Gagan

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