BigQuery, Snowflake & ClickHouse Timestamp Converter

Q: What is the InfluxDB timestamp format?

**RFC 3339 with nanoseconds**: `2026-08-13T14:30:00.123456789Z`. Line protocol timestamps default to ns precision.

Cloud data warehouses each serialize timestamps slightly differently: BigQuery (ISO 8601 with `T`/space), Snowflake (microsecond ISO), ClickHouse (ISO 8601), kdb+ (internal int64), InfluxDB (RFC 3339 nanosecond) and Presto/Hive (ISO 8601).

This converter renders your date-time in each warehouse's canonical form so you can build SQL strings, check COPY/LOAD outputs, and debug timestamp column rendering.

Timezone:

Enter a date-time above to see the conversion results.

BigQuery, Snowflake & ClickHouse Timestamp Converter Quick Reference

Format	Pattern / Description	Example 1	Example 2
BigQuery TIMESTAMP	UTC Standard	2026-08-13 14:30:00 UTC	2026-01-01 00:00:00 UTC
Snowflake TIMESTAMP_TZ	With timezone offset	2026-08-13 14:30:00.000 +0000	2026-01-01 00:00:00.000 +0000
ClickHouse DateTime64	YYYY-MM-DD HH:mm:ss.nnnnnnnnn	2026-08-13 14:30:00	2026-01-01 00:00:00
Kdb+ / q Timestamp	yyyy.MM.ddD...	2026.08.13D14:30:00.000000000	2026.01.01D00:00:00.000000000
InfluxDB Line Protocol	Timestamp (Seconds)	1786631400	1767225600
Presto / Hive / Trino	YYYY-MM-DD HH:mm:ss Zone	2026-08-13 14:30:00 UTC	2026-01-01 00:00:00 UTC

* Examples are rendered in UTC for the fixed sample instants above.

When to Use BigQuery, Snowflake & ClickHouse Timestamp

Data warehouse loading

Generate engine-correct timestamp literals for COPY INTO, INSERT and query filters in BigQuery/Snowflake.

Schema & column type debugging

Check how each warehouse renders `TIMESTAMP`, `TIMESTAMP_NTZ` and `DateTime64` columns for comparison with source data.

Data lake partitioning

Produce consistent timestamp strings for Hive/Presto partition keys across engines.

Frequently Asked Questions

What is the BigQuery timestamp format?

ISO 8601 with a space or T separator: `2026-08-13 14:30:00 UTC` or `2026-08-13T14:30:00Z`. BigQuery also supports RFC 3339 strings in DML.

What is the Snowflake timestamp format?

`TIMESTAMP_NTZ` renders `2026-08-13 14:30:00`; `TIMESTAMP_TZ` adds the offset: `2026-08-13 14:30:00 +00:00`. Microsecond precision by default.

What is the ClickHouse DateTime format?

ISO 8601: `2026-08-13 14:30:00` for `DateTime`, `2026-08-13 14:30:00.123456` for `DateTime64`. Internal storage is Unix-style seconds since epoch.

What is the InfluxDB timestamp format?

RFC 3339 with nanoseconds: `2026-08-13T14:30:00.123456789Z`. Line protocol timestamps default to ns precision.

Related Time Format Converters

SQL Datetime Format Converter

Convert dates to SQL datetime formats: standard YYYY-MM-DD HH:mm:ss, MySQL TIMESTAMP, PostgreSQL and SQL Server styles. Free converter for database work.

Avro & Parquet Timestamp Converter

Convert dates to Avro and Parquet logical timestamp types: date, time-millis, time-micros, timestamp-micros and INT96. Free converter for data engineering.

ISO 8601 Date & Time Converter

Convert any date-time to ISO 8601 format: extended, basic and interval forms. Free converter with pattern reference, examples and FAQ. UTC & local timezone support.

All Format Guides

Unix Timestamp ISO 8601 ISO Week Date ISO Ordinal Date Military Time Decimal Time RFC 2822 RFC 3339 SQL Datetime Julian Date HTTP Date Excel Serial Date GPS Time UTC Time Cron Expression

Browse all 50 format guides →

Need to Convert Between All Formats?

Use the main Time Format Converter for instant conversion across 100+ formats — epoch, ISO 8601, RFC 3339, SQL datetime, military time and more in one click.

Open Time Format Converter