I'm trying to convert a 12-hour time (example: 6/17/2010 2:44:56 PM) to be 24-hour timestamp in postgres. I've tried to_timestamp and it doesn't work. Ideally it would end up being 2010-06-17 14:44:56.