where you want to manipulate the value? During INSERT operation?

Or you are trying to build SQL Query to retrieve the data as per your need?