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

<!--TODO: Replace the `DBDateTime` logic in this doc with standard Java logic - Core+ workers should expect to use the Core API, which hasn't used the internal `DBDateTime` stuff in a long time-->

> [!NOTE]
> The document's screenshot and code examples use `db.t`, `DBDateTime` date times, and `getMeta`, but the concepts also apply to Core+ and `db.historicalTable`, `Instant` date times, and `meta`.

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:

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

![The above `quotes` table](../../assets/faq/faq1.png)

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:

![The tooltip for the `Timestamp` column appears when the user hovers the mouse over it](../../assets/faq/faq2.png)

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

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

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

```
Meta = quotes.getMeta()
```

![The above `meta` table](../../assets/faq/faq3.png)

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:

![The UI **Settings** panel](../../assets/faq/faq4.png)

![The Timestamp formatting options in the **Settings** panel](../../assets/faq/faq5.png)

## Related documentation

- [Time in Deephaven](/core/docs/conceptual/time-in-deephaven)