Originally posted by PSoni
02-07-0003
Even I wasn't born then!

Originally posted by PSoni
to_date(datecolumn,'dd-mm-yyyy')
This is TOTALLY SKREWY. Why are you doing this? If datecolumn is a DATE you don't need to convert it! If you want to trim off the time part, TRUNC(datecolumn) will do it.

If you want to do date manipulations in procs, then I would insist that any convertions were coded with an explicit format. If you don't agree then we will send round Mr.Hanky to sort you out