Date functions not returning Data Properly.

[tgtwm1github]

Bug Report

select date(current_timestamp()), current_time
,format_timestamp( "%Y-%d-%m",current_timestamp)

Does not return proper result using the plugin.

However it works fine in Native GCP console.

Expected Behavior

select date(current_timestamp()), current_time
,format_timestamp( "%Y-%d-%m",current_timestamp)

Row	f0_	f1_	f2_
1	2021-01-03	19:01:09.920693	2021-03-01

Actual Behavior

select date(current_timestamp()), current_time
,format_timestamp( "%Y-%d-%m",current_timestamp)

f0_ f1_ f2_
Invalid Date 19:02:39.712327 2021-03-01

Steps to Reproduce the Problem

Specifications

• Version:2.0.1
• Platform: Linux
• Grafana Version: 7.3.5

[ofir5300]

Hi, this issue is duplication of Same Query - Different Results from Google Console vs. Grafana-Doit-bigquery plugin #297
Issue closed.