Date Quotes

Database

Date Quotes

Hello, 

I am a new developer in Teradata world and I'm having to take the quotes from a variable to a software returns me.

I have that: a12.Calendar_Dt in (DATE '11/26/2013')

I can manipulate the start and the end of the variable but not the center.

I wanted converts the variable in: a12.Calendar_Dt in (DATE 26/11/2013)

Is there any way?
Tags (2)
1 REPLY
Enthusiast

Re: Date Quotes

IF its date formatting, you are looking for, use cast.

If its just removing single quotes, use oreplace.