Are SQL data source date functions performed on Klipfolio's servers?


I have an SQL data source which connects to a Microsoft SQL server. The script uses the function GETDATE() as a part of the query to limit the results to the current day. I'm not entirely certain how Klipfolio handles SQL scripts. Is the GETDATE() function performed somewhere on Klipfolio's end and then queried or is it sent as it is to my SQL servers? If it's performed somewhere on Klipfolio's end, which timezone does it use so I can create an offset? The reason I'm asking is because a user reported seeing data for the previous day at around 2AM and the only explanation I can come up with is this. I tried using "debug_info" on the data source but couldn't find anything that way.


Best regards,

Carlos Kynäslahti

1 comment

Please sign in to leave a comment.