in reply to Re^6: Date format
in thread Date format
"Yes, I have already tried this(FMdd/FMmm/FMyyyy), it was not coming."
Had you copied and paste the code I gave you I'm pretty sure it'd work on any Oracle database. You still don't show what SQL you are actually running, or how it fails, and FM doesn't work the way you assume it does. Think of it as a toggle, and read the documentation to understand what you're trying to use.
select to_char(sysdate - interval '4' hour, 'fmdd/mm/yyyy HHfm:mm') fr +om dual 6/9/2018 8:09
I set the system date back a few hours to illustrate the format you say you want because of my timezone. Please read and understand How do I post a question effectively? & PerlMonks for the Absolute Beginner.
|
|---|