The new GUI for SQL developer from Oracle, does not seem to show "time" value for a timestamp field when doing a select statement. I tried setting options, but did not help. Till I get a real solution, here is a workaround:
select to_char(calendar_date,'DD-MON-YYYY HH24:MI:SS')) from W_Day_D
No comments:
Post a Comment