Date/Time format in results grid

[imadsafieddine]

Hi, I'm using both dbForge Studio Express for Oracle, and SQL Developer by Oracle.

For the same result of a timestamp, I get the following:
in dbForge Studio : 2013-03-21 09:55:42.834000
in SQL Developer : 03/21/2013 09:55:42.834000000 PM

I don't mind the date format, but dbForge is missing a very important information : 'PM'.

Where is it possible to change the time format to have it either in HH24, or with AM/PM?

Thanks

[alexa]

Unfortunately, there is no such a possibility. However, we will add it in one of the next product versions.

[alexa]

This can be setup as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> Formatting' section.
3. In the 'Datatype' drop-down menu, select 'Timestamp'.
4. In the 'Edit format' field, specify the following string:

Code: Select all

yyyy-MM-dd hh:mm:ss.ffffff tt

5. Click 'OK'.

Please also see the following topic in the product's Help documentation https://www.devart.com/dbforge/oracle/s ... og_box.htm

[imadsafieddine]

Hi, that's exactly what I was looking for.

Thanks a lot