How may a date difference be calculated in Google Cloud SQL?

  • 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 Google Cloud SQL function can I use to figure out this date difference?

    present code

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

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Dion

    (@diondesigns)

    You should be asking this question on dba.stackexchange.com or a Google Cloud support site. It has nothing to do with WordPress.

Viewing 1 replies (of 1 total)
  • The topic ‘How may a date difference be calculated in Google Cloud SQL?’ is closed to new replies.