Hi
I have the following problem using sybase 7.0.3.2107.

I am trying to display the date using the format yyjjj - julian date
year then nth day of the year.

eg dateformat(20040127,'YYJJJ')

I want the day fields to be padded with zeros so I am using the same
case letters.

If I execute the following in isql it returns "04027" which is what i
expect and want.
select dateformat(20040127,'YYJJJ')

However if I use same text in a select statement in a stored procedure
it does not pad the day figure with zeros. Instead it returns "0427".

What am I missing here?


please help - hopefully I am just tired and missing something basic