How do i change date format in the database
Recommended Answers
Jump to PostHow do i change date format in the database
Take a look at the TO_CHAR function
Jump to PostALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY';
PLEASE USE THE ABOVE CODE
All 7 Replies
rbirnale
0
Newbie Poster
To change date type use to_char() function.
debasisdas
580
Posting Genius
Featured Poster
ALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY';
PLEASE USE THE ABOVE CODE
Musta
0
Newbie Poster
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()
yogesh_vaidya12
0
Newbie Poster
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'))
dhineshbcs
0
Newbie Poster
Can Any one tell how to convert String datatype 2 sql
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.