Showing posts with label TIMESTAMP. Show all posts
Showing posts with label TIMESTAMP. Show all posts

Tuesday, February 5, 2013

Timestamp fields in database not showing in SQL Developer

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