• it is VARCHAR and the above works fine i just need the AM/PM part as well