Skip to main content

Formatting date representations in DBeaver

The open source database client DBeaver has the ability to specify a format in which to present date and time values in results sets.  The tables defined here identify the date and time parts and what they will represent when used as part of the mask.

To open the settings:

  1. Select File | Preferences
  2. Expand the Common item
  3. Choose the Date Formats item

From the settings on the right side of this dialog, look for the Type pop-up menu and the Settings Name/Value fields.  There is a Name/Value combination for each item in the Type pop-up menu.  A custom mask can be supplied for the desired presentation of date and time data.


Shorthand Description Example
Date
d Day without leading zero 7
dd Day with leading zero 07
M Month without leading zero 1
MM Month with leading zero 01
MMM Abbreviated month Jan
MMMM Formal month January
yy Short year 13
yyyy Full year 2013
Time
a AM/PM (upper case) AM
h Hour without leading zero 9
hh Hour with leading zero 09
m Minutes without leading zero 8
mm Minutes with leading zero 08
s Seconds without leading zero 5
ss Seconds with leading zero 05
z Time zone (upper case) EST
Labels:

Comments

Post a Comment

Popular posts from this blog

PHP built-in webserver and IPv6 addresses

Though it's difficult to confirm around the Web, it appears as though the IP address scheme the built-in PHP server uses depends on the host name that's provided.  If a fully-qualified domain name (FQDN) is used, such as server.domain.tld, then the built-in server will be listening for IPv6 based requests.  If the server is started with an IPv4 address identified as the host, then it will naturally listen for IPv4 based requests. The closest to anything official around the Web was a comment in the PHP docs that only seeded this conclusion, at best.  But here it is in any case. Built-in web server http://php.net/manual/en/features.commandline.webserver.php#120449 Ultimately, the following answer from Stack Overflow held the "universal" solution.  Thank you dew010. Running PHP 5.4 built-in web server outside localhost http://stackoverflow.com/a/8377378/2487485 Start your development server like: php -S 0.0.0.0:8989
Post a Comment
Read more

HP webOS interface kudos

UPDATED 06/07/2013 Pandora no-longer makes the webOS version of its player available. While quite obviously a piece rooted in opinion, a subtle nod is offered to Palm for the excellent interface work it did with webOS .  Since it’s initial release with Sprint in June 2009, Palm quickly slipped into relative oblivion.  With the recent purchase of the company by HP coupled with new product releases set for the summer, webOS may become relevant once again.  If so, then perhaps a whole new lot of users will come to appreciate the consideration that was taken with the webOS user interface (UI). An example is the popular webOS application for the even more popular Pandora Internet radio service.  And as it turns out, the company has a collection of screen captures for the various mobile platforms that have native applications for the service.  This happens to double as a quick way to compare the interface elements of other platforms by using the same applic...
Post a Comment
Read more

Allow Windows authentication using SQL Server driver with DBeaver

DBeaver will allow Microsoft Windows single sign on access when connecting to Microsoft SQL Server using the SQL Server driver (rather than jTDS ).  From the driver properties settings, set the integratedSecurity flag to true . Open the Connection configuration panel and choose the Driver properties section. Set the integratedSecurity flag to true . A subtle, but important step is to not provide username and password credentials to the connection.
7 comments
Read more