converting date to month string

[mwhalen]

in a query, does anyone know of the function and syntax to return a portion of the date as a month?

 

[tzamora]

create an expression



SELECT A.ACQUISITION_DT, MONTH( A.ACQUISITION_DT)
FROM PS_ASSET A
WHERE A.ASSET_ID = '000000018629'

http://programmer-by-the-hour.com