# TIMESTAMP

Convert the input argument to a datetime object.

## Syntax

```
TIMESTAMP(dateobj)

```

## Arguments

* dateobj: a valid date, datetime, or parsable date string.

## Return Type

Datetime object. If dateobj is not a valid date, returns NULL.

## Remarks

* `TIMESTAMP` is based on UTC timezones. 
* SingleStore converts `TIMESTAMP` values from the current timezone to UTC for storage.
* **Minimum value**: when setting a value for `TIMESTAMP`, if your UTC timezone is before UTC (set to UTC +\<hours>) and you set `TIMESTAMP` to its minimum value (`1970-01-01 00:00:01`), the query will insert `0000-00-00 00:00:00`.
* The `TIMESTAMP` function supports improved segment elimination (A process where metadata stored for columnstore segments is used to determine where a segment can match a filter queried at execution time.) when used in `WHERE` clauses. See the following query example:
  ```sql
  SELECT ... FROM table_name WHERE TIMESTAMP(column_name) > '2000-01-01 00:00:00' AND TIMESTAMP(column_name) <= '2015-03-03 00:00:00';
  ```

## Examples

```sql
SELECT TIMESTAMP('2015-03-03');

```

```output

+-------------------------+
| TIMESTAMP('2015-03-03') |
+-------------------------+
| 2015-03-03 00:00:00     |
+-------------------------+

```

**Related Topics**

* [TIMESTAMPADD](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/timestampadd.md)
* [TIMESTAMPDIFF](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/timestampdiff.md)

***

Modified at: March 21, 2025

Source: [/cloud/reference/sql-reference/date-and-time-functions/timestamp/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/timestamp/)

(An index of the documentation is available at /llms.txt)