• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to concatenate inside an escape function for Derby

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Don't worry about the logic yet, I wonder how I can concatenate inside an escape function
I want to say if the person's birthday is 1950-10-10, I will get something like 2013-10-10
The above shows the following error
Error code -1, SQL state 42X01: Syntax error: Encountered "||" at line 8, column 100.
Any ideas?
Thanks
Jack
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic