using update in oracle

Question

I have a column named date_col of data-type date. What's wrong with this query?

update test set date_col = to_date(sysdate,'DD-Mon-YYYY HH24:MI:SS')

Only date mon and yy is visible. not the time.

How can I make it work?

Try, SELECT TO_CHAR(date_col, 'DD-MON-YYYY HH24:MI:SSxFF') From Table — KV Prajapati
– KV Prajapati, Commented Sep 4, 2012 at 6:50
Then edit your post and remove this - only date mon and yy is visible — KV Prajapati
– KV Prajapati, Commented Sep 4, 2012 at 6:54

dani herrera · Accepted Answer · 2012-09-04 06:49:57Z

2

SYSDATE is yet a date. You don't need to cast SYSDATE to date type because it is a date_

update test 
set date_col = sysdate

To see time fraction use to_char:

select to_char(date_col, 'HH24 MI')
from test;

answered Sep 4, 2012 at 6:49

dani herrera

52k11 gold badges133 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1