In Google Cloud SQL, how can you figure out a date difference?

[sunny11]

I'm attempting to create a query that would show the difference in date between a date recorded in a column and the current date, but I keep receiving the following error:

"Cannot call method "getTime" of null."

What function can I use to calculate this date difference in Google Cloud SQL?

Current code:

SELECT date, DATEDIFF(date, CURRENT_DATE()) AS daysLeft
FROM table;

 

[matja]

* It's `DATE_DIFF`, not `DATEDIFF` (reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff)
* You need to specify what units to return, usually will be `DAY`.

The rest looks ok in your query, so I'd guess this should work:

SELECT date, DATE_DIFF(date, CURRENT_DATE(), DAY) AS daysLeft
FROM table;

No idea where `getTime` is coming from, do you have another (sub)query somewhere?

 

[sunny11]

* It's `DATE_DIFF`, not `DATEDIFF` (reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff)
* You need to specify what units to return, usually will be `DAY`.

The rest looks ok in your query, so I'd guess this should work:

SELECT date, DATE_DIFF(date, CURRENT_DATE(), DAY) AS daysLeft
FROM table;

No idea where `getTime` is coming from, do you have another (sub)query somewhere?

Thanks, I think this will work.