Tweet
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.
-
-
How to concat numerical fields
Ken: Thanks for your tip. -
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