Time zones in date time strings

[lou.lo...@foghorn.io]

The date/time strings we're sending over to pub/sub look like this:

2018-07-18T17:30:08Z

I created a data flow job to insert these into Big Query and it failed at insert.

Stripping out the "Z" at the end like this was successful:

2018-07-18T17:30:08

The problem is that Big Query seems to be interpreting this as a local time, and not UTC.

I've tried both of these ways to insert the time zone:

2018-07-18T17:30:08+00:00

2018-07-18T17:30:08+0000

Both are rejected.

What's the correct way to do this, or is there some other way I can force Big Query to interpret these times as UTC?

[Misha Brukman]

Hi Lou,

Your question is about BigQuery (data warehouse), while this list is for Bigtable (NoSQL database).

Please see https://cloud.google.com/bigquery/support for BigQuery support options.

Best,

Misha

--
You received this message because you are subscribed to the Google Groups "Google Cloud Bigtable Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-bigtable-discuss+unsub...@googlegroups.com.
To post to this group, send email to google-cloud-bigtable-discuss@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-bigtable-discuss/ed09da79-982c-47b8-af13-946d36733c73%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[lou.lo...@foghorn.io]

My mistake - thanks

On Wednesday, July 18, 2018 at 2:18:01 PM UTC-4, Misha Brukman wrote:

Hi Lou,

Your question is about BigQuery (data warehouse), while this list is for Bigtable (NoSQL database).

Please see https://cloud.google.com/bigquery/support for BigQuery support options.

Best,

Misha

On Wed, Jul 18, 2018 at 1:39 PM, lou.loizides via Google Cloud Bigtable Discuss <google-cloud-bigtable-dis...@googlegroups.com> wrote:

The date/time strings we're sending over to pub/sub look like this:

2018-07-18T17:30:08Z

I created a data flow job to insert these into Big Query and it failed at insert.

Stripping out the "Z" at the end like this was successful:

2018-07-18T17:30:08

The problem is that Big Query seems to be interpreting this as a local time, and not UTC.

I've tried both of these ways to insert the time zone:

2018-07-18T17:30:08+00:00

2018-07-18T17:30:08+0000

Both are rejected.

What's the correct way to do this, or is there some other way I can force Big Query to interpret these times as UTC?

--
You received this message because you are subscribed to the Google Groups "Google Cloud Bigtable Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-bigtable-discuss+unsub...@googlegroups.com.

To post to this group, send email to google-cloud-b...@googlegroups.com.