Hi Gurus,
Unless we alter the NLS date parameter , oracle stores date in mm/dd/yyyy format.
Is there a way we can store date in yyyy-mm-dd format in a particular table as a date?
Using to_char(sysdate,'yyyy-mm-dd') serves the purpose but this will be a string instead of Date.
Is there a way we can convert date to yyyy-mm-dd format which will be a date and not a string?
Thanks