Member Avatar

How do i change date format in the database

  • 7 Contributors
  • forum 7 Replies
  • 241 Views
  • 5 Years Discussion Span
  • comment Latest Post Latest Post by dhineshbcs

Recommended Answers

Answered by aniseed 38 in a post from

How do i change date format in the database

Take a look at the TO_CHAR function

Read more here

Jump to Post
Answered by debasisdas 580 in a post from

ALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY';

PLEASE USE THE ABOVE CODE

Jump to Post

All 7 Replies

Member Avatar

How do i change date format in the database

Take a look at the TO_CHAR function

Read more here

Member Avatar

Take a look at the TO_CHAR function

Read more here

Thanks for your reply the problem is solved

Member Avatar

To change date type use to_char() function.

Member Avatar

ALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY';

PLEASE USE THE ABOVE CODE

Member Avatar

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()

Member Avatar

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'))

Member Avatar

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!