Oracle datetime fields

Jaspal Hayre

Hi All

 

We are using v9.1 with Oracle 11gR2. When I use Oracle SQL developer to query the Metastorm system tables all the datetime fields are only showing date values e.g. eCreationTime will show 26-JAN-12 but not the time same for eEventTime etc. 

 

I'm not sure if this is an issue with SQL Developer as I get the same when I open a table or use a select query or that only date values are being stored?

Jaspal Hayre

Must Oracle SQL Developer as I just checked web client shows full date and time for Last Updated in To-Do list - Panic over

Grzegorz Lag

This is some setting in sqll developer as I remember. You can also use to_char for any date column in every query;-)