recite : sybase count char from 1 !!

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’

Advertisements

Author: lwpro2

Java J2EE professional

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s