All Forums Database
ledaher 1 post Joined 05/15
27 May 2015
Date Quotes


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?

yuvaevergreen 93 posts Joined 07/09
28 May 2015

IF its date formatting, you are looking for, use cast.
If its just removing single quotes, use oreplace.

You must sign in to leave a comment.