How do I display timestamp values in my table with or without the date?

The DBDateTime variable common in the timestamp column includes both the date and time (e.g., "2020-06-08T12:00 NY"). However, the UI may be set up to display only time. For example, the "StockQuotes" table in the "LearnDeephaven" namespace opens as shown below:

quotes = db.t("LearnDeephaven", "StockQuotes").where("Date=`2017-08-25`")

The Timestamp column displays only the time. However, this is actually a DBDateTime. You can determine this in one of two ways:

1. Hover over an individual column header:

2. Use the getMeta method to see information about all the columns:

t = db.t("LearnDeephaven","StockQuotes").getMeta()

Or, since in our example case the "quotes" table is already open,

Meta = quotes.getMeta()

Determining the correct data type is important because, for instance to filter the timestamp column, your query must include the full format (e.g., "Timestamp='2020-06-08T12:00 NY'").

You can display the full value by adjusting the UI settings:

Last Updated: 16 February 2021 18:06 -04:00 UTC Deephaven v.1.20200928 (See other versions)