All Forums Database
ledaher 1 post Joined 05/15
27 May 2015
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?
 

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.