Yannick Chaze
Yannick Chaze

Reputation: 576

Whiy BigQuery return float value in scientific notation?

I have a table with a column that stored the last update time in epoch time as a FLOAT value.

When I query for this column I get it as a scientific notation like this:

1.385627666E9

How can I get the value in plain format like this:

1385627666

I have tried to cast it in String but it is worst.

Upvotes: 0

Views: 2277

Answers (1)

Yannick Chaze
Yannick Chaze

Reputation: 576

It seems that to cast the value as an integer just works fine:

SELECT INTEGER(last_update) FROM my_table

Upvotes: 1

Related Questions