Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This example query would cause the following error:

Code Block
languagesql
linenumberstrue
SELECT td_time_format(time) from pageviews;

Error:

Code Block
languageruby
linenumberstrue
Unexpected parameters (bigint) for function td_time_format. 
Expected: td_time_format(bigint, varchar, varchar) , td_time_format(bigint, varchar)

...

Cause

This error occurs when the number of arguments or the data type provided in the function is different from those specified for that function.

...

Resolution

Provide the correct number and type of arguments required for the function. See the notes for the correct number and type of arguments.

Fixed query:

Code Block
languagesql
linenumberstrue
SELECT td_time_format(time, 'yyyy-MM-dd HH:mm:ss', 'UTC') from pageviews;

...

Notes