question

BI DWH BALA avatar image
BI DWH BALA asked

Can we change default date format in oracle?

Can we change default date format in oracle?

When we display sysdate, it displays in a defined format. I want to change the format to a user defined format.

Can we do this?

Thanks in advance.

oracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KillerDBA avatar image
KillerDBA answered

I found a discussion of that subject here:

OTN Discussion Forums

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.