Oracle datetime fields

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?

Find more posts tagged with

BPM

Comments

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;-)