Bigquery - select timestamp as human readable datetime -

how select timestamp(stored seconds) human readable datetime in google bigquery?

schema

id(string) | signup_date(timestamp) 

i wrote query using date function, getting error

select date(create_date) [accounts]  

error: invalid function name: date; did mean case?

thanks!

i think found working solution bigquery reference page. bigquery stores timestamp data internally unix timestamp microsecond precision.

select sec_to_timestamp(date) ...