followup
A reader, October 16, 2017 - 3:59 am UTC
thanks...is it possible without altering a session or changing data type of out parameter?
Please suggest.
October 16, 2017 - 12:33 pm UTC
No. You have to set the NLS parameters or (better) use to_char with a mask to set the format.
NextName, October 16, 2017 - 12:41 pm UTC
Wouldn't it be advisable to simply leave the procedure's output parameter a date -- and let the "consumer" (presentation layer/application/...) handle the formatting issure?
IOW, leave the date format as long as possible ...
October 16, 2017 - 2:42 pm UTC
Yes, it's a good idea to leave it as a date as possible. Particularly if you need to do arithmetic or similar processing on the value.
A reader, October 16, 2017 - 12:54 pm UTC
Thanks Chris!!!