Time stamp is not visible.

A Java SQL client for any JDBC compliant database

Brought to you by: colbell, gerdwagner

#426 Time stamp is not visible.

Milestone: General

Status: closed

Owner: Stefan Willinger

Labels: Oracle Plugin (23)

Priority: 4

Updated: 2011-05-18

Created: 2011-05-17

Creator: progs_backup

Private: No

If the column contains date and time value for a datatype date, then only date is visible not time!

Discussion

progs_backup - 2011-05-17

ss.JPG

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stefan Willinger - 2011-05-17

This is the intended behavior. You can force Squirrel to interpret a date column as a timestamp. To do this, go to - Global Preferences => Data Type Controls => Date => "Interpret DATE columns as TIMESTAMP"

Please tell us, if this is useful for you.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

progs_backup - 2011-05-18

It would be very nice, if you keep this as a default behaviour for oracle database at least.

Thanks you very much it worked.!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

progs_backup - 2011-05-18

assigned_to: manningr --> wis775

priority: 5 --> 4
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Stefan Willinger - 2011-05-18

status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.