01-JAN-15 00:00:00 change to 01-JAN-2015 using SQL in SQL Developer

Question

01-JAN-15 00:00:00 change to 01-JAN-2015 using SQL in SQL Developer

Current Output:

01-JAN-15 00:00:00

Expected Output:

01-JAN-2015

Using SQL

It's impossible to answer this question with so little context. Are you performing a query? an update? can you share your statemtn? — Mureinik, Jan 28 '19 at 06:17
Date column output is 01-JAN-15 00:00:00. But I would like to get the output as 01-JAN-2015 — user9803698, Jan 28 '19 at 06:27

score 1 · Answer 1 · answered Jan 28 '19 at 06:58

1

i think what you need is the view of sql developer - the way you want

You can do it from this path - in sql developer

Tools --> preferrence --> Database --> NLS

Check below screen shot

answered Jan 28 '19 at 06:58

Ashish Shetkar

1,324
2
19
32

score 0 · Answer 2 · edited Jan 28 '19 at 08:37

0

TRUNC (date):

The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. The value returned is always of datatype DATE, even if you specify a different datetime datatype for date. If you omit fmt, then date is truncated to the nearest day.

You can use this as below:

select trunc(column_name) from table_name;

edited Jan 28 '19 at 08:37

Wai Ha Lee

8,173
68
59
86

answered Jan 28 '19 at 06:36

Muhammad Waheed

960
1
11
29

That returns the same value as user9803698 already sees – a_horse_with_no_name Jan 28 '19 at 08:03
I have tried on TOAD using Oracle 11g R2 and it's working. – Muhammad Waheed Jan 28 '19 at 08:09
I've added quote formatting to that block of text as it looks like you've copied it verbatim from an external source. To avoid plagiarism you must (at the very least) add attribution to the original source. – Wai Ha Lee Jan 28 '19 at 08:40

01-JAN-15 00:00:00 change to 01-JAN-2015 using SQL in SQL Developer

2 Answers2