[kbailey]

Since I installed version 6.0.1 of MyEclipse, when I run SQL and SELECT * or specific column names from a database, if data returned includes DATEs I receive the entire date with timestamp yyyyddmm hh:mm:ss.x . I was running an old version of MyEclipse prior to 6 and did not have this problem. My databases contain many different types of dates including date of birth, graduation date, etc, and having them displayed with 00:00:00.0 times is a problem for me.

Is there a way to default the output of dates (at startup) with just yyyyddmm???

I know I can do to_char but I have hundreds file scripts written and having to recode each of them, or remember to format the date each time I create a new script to remove the timestamp is not a option.

I only use MyEclipse to run SQL script to output data database tables.

[Loyal Water]

There is no way to do this from inside ME, it is just displaying the raw field data it gets back from the driver.

The driver you are using may have changed the default display format for dates which is why ME is showing it differently. That might be an option for you (downgrade the JDBC driver).

[Author]

Posts