DATENAME function

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

DATENAME function

Hi,

 

i need convert DATENAME function to TeraData:

DATENAME(dw,GETDATE()) = 'Thursday'

 

someone know if there is Parallel function in TeraData?

 

 

Tx!!!

2 REPLIES
Senior Apprentice

Re: DATENAME function

Hi,

 

You can use the FORMAT capability:

date (format 'eeee')

If you're running this from SQLA or Studio you can test it with:

select cast( (date (format 'eeee')) as char(20))

Cheers,

Dave

 

 

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Highlighted
Junior Contributor

Re: DATENAME function

Or

SELECT To_Char(Current_Date, 'Day')