You want to specify a specific column (timestamp type) for the data table in a big query to extract only data within any period of time.
·Satei_date is within 2 months
The query is listed as follows, but an error occurs.
I would appreciate it if you could tell me the cause and how to fix it.
WHERE sitei_date BETWEEN CURRENT_DATE() and DATE(CURRENT_DATE, INTERVAL-2 MONTH)
No matching signature for operator BETWEEN for argument types: TIMESTAMP, DATE, DATE.Supported signature: (ANY) BETWEEN (ANY) AND (ANY)
Error trying to compare TIMESTAMP and DATE types.
I don't know what database you are using, but I think you should use a function that converts the value returned by CURRENT_DATE() into a TIMESTANP type.
581 PHP ssh2_scp_send fails to send files as intended
914 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
618 Uncaught (inpromise) Error on Electron: An object could not be cloned
611 GDB gets version error when attempting to debug with the Presense SDK (IDE)
© 2024 OneMinuteCode. All rights reserved.