Date/Time format in results grid

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
imadsafieddine
Posts: 2
Joined: Thu 21 May 2015 17:20

Date/Time format in results grid

Post by imadsafieddine » Thu 21 May 2015 17:27

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
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Date/Time format in results grid

Post by alexa » Fri 22 May 2015 13:05

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

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Date/Time format in results grid

Post by alexa » Mon 25 May 2015 11:25

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
Posts: 2
Joined: Thu 21 May 2015 17:20

Re: Date/Time format in results grid

Post by imadsafieddine » Mon 25 May 2015 13:38

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

Thanks a lot

Post Reply