in reply to date reformatting

Here's a Sybase-specific solution to show the current date in the mm/dd/yy format:
select convert(varchar(8), getdate(), 1)
For your case, just replace the getdate() with whatever value you're trying to display in that format Most likely it's a column, but as I've shown here, it can be anything that returns a datetime.

thor

Feel the white light, the light within
Be your own disciple, fan the sparks of will
For all of us waiting, your kingdom will come