How to write below SQL query in BigQuery

Question

The below statement is in SQL code. How do I write it in BigQuery?

select to_number(to_char(sysdate,'yyyy')) from dual

what do you mean by "big query" ? Provide corresponding links to the tools you are referring. — SRIDHARAN
– SRIDHARAN, Commented Jul 25, 2020 at 7:05

Gretski · Accepted Answer · 2020-07-24 19:08:02Z

2

Try something like:

SELECT EXTRACT(YEAR FROM CURRENT_DATE()) as the_date;

answered Jul 24, 2020 at 19:08

Gretski

4614 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Soumendra Mishra · Accepted Answer · 2020-08-26 12:45:11Z

0

You can try this:

SELECT FORMAT_DATETIME("%Y", CURRENT_DATE()) as current_year;

answered Aug 26, 2020 at 12:45

Soumendra Mishra

3,7131 gold badge18 silver badges40 bronze badges