Home:ALL Converter>Max value of VARCHAR field oracle

Max value of VARCHAR field oracle

Ask Time:2013-08-14T03:29:10         Author:user1466935

Json Formatter

I have a field that I would like to get the max value of but it is a varchar2(6) field, all numerals. I am unable to change the type of field

The field is a date listed like this 201307 for July 2013. Just using MAX does not work.

Using oracle.

Author:user1466935,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/18217543/max-value-of-varchar-field-oracle
yy