Even I wasn't born then!Quote:
Originally posted by PSoni
02-07-0003
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.Quote:
Originally posted by PSoni
to_date(datecolumn,'dd-mm-yyyy')
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 ;)