Convert them to character first. Something like digits(MM) concat '/' concat digits(dd) concat '/' concat digits(yy) As written, it'll look OK only if the fields are defined as having 2 digits. If they're 3 or longer, you may have to remove leading zeros with SUBSTRING.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
How to concat numerical fields
Collapse
X
-
How to concat numerical fields
We have an item file which has 3 numerical fields to hold year,month and day. I have to cat them in MM/DD/YY format in SQL and got a error "Argument * N of function CONCAT not valid". I found that CONCAT function wouldn't work on numerical field. Please help. Many thanks.
Comment
Comment