let’s say ’05:00′, to get the hour, should be substring(1, 2)
to get the miniute should be substring(3, 2).
besides, char is fixed length is fixed length, for example char(5) would pad ‘5:00′ with ?? at end of ’00’
recite : sybase count char from 1 !!
Published
