Date format picture ends before converting entire input string
450482Oct 15 2007 — edited Oct 15 2007Hi
In the database, I have a timestamp column (that translates to Character in reports builder). I am trying to access just the date part. If I try use do to_date, i get the following error:
Ora-01830: Date format picture ends before converting entire input string
Is there some other way that I can use to fetch just the date in dd-Mon-yyyy format?
Thx!