Date Conversion


Date Conversion

Hi - I'm trying to convert a datetime variable to a date in the format like 14JAN2014. I can parse out the date portion using CAST(create_dt_tm as DATE FORMAT 'mmddYYYY'). However, I'm not having any luck getting Teradata to put the date in anything except a numerical format. In other databases I use something like format 'ddMonyyyy' but that doesn't work in Teradata. Is it possible? Thanks!!

Junior Contributor

Re: Date Conversion

It's FORMAT 'ddmmmyyyy'