Reputation: 576
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
Reputation: 576
It seems that to cast the value as an integer just works fine:
SELECT INTEGER(last_update) FROM my_table
Upvotes: 1