devxlogo

Dates in String Variables

Dates in String Variables

Question:
I want to use a string variable with the date in it (format would be 02/22/96). How do I accomplish this?

Answer:
You’ll need to first convert the date to a string (the name of the function to do this varies with each product, so you’ll have to checkyour documentation). Then, concatenate the rest of the string around the date, for example:

SELECT string||converted_date||rest_of_string      FROM TableA;
The double bars are the concatenation operator. Some languages also support a correlation name (alias) if you were selecting the concatenated string as I demonstrated above. For example, you might be able to use:
SELECT string||converted_date||rest_of_string AS stringa      FROM TableA;
In this example, the result set would be labeled “stringa” rather than the long “string||converted_date||rest_of_string” that might appear if you do not (or can not) use a correlation name.
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist