7
Contributors
7
Replies
8
Views
11 Years
Discussion Span
Last Post by dhineshbcs
0

The Alter session is a temporary solution, that makes your session only appears with the format specified..
If you want to create a report or a query or a script that always appear with a specific format then go with TO_CHAR()

0

Use To_char Function
To_char(date,'dd-mm-yyyy') In Which Format You Use
Also To_date Function
To_date(date,'dd-mm-yyyy')
Also
To_char(to_date(date,'dd-mm-yyyy'),'dd-mm-yyyy'))

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.