View Full Version : How to concat numerical fields
12-27-2004, 12:55 PM
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.
01-10-2005, 06:57 AM
Ken: Thanks for your tip.
01-10-2005, 01:26 PM
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.
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.