I need to do some date comparisons in an Process Plan and this means comparing dates with SQL. I'm developing the script that I will eventually use for the Process Plan in Object browser. When I run the following code
select getdate() as today, * from person where centralaccount = 'something'
The date that is returned is the 14/12/2017. Today is the 13th though. I checked all the job servers and database servers and they all have the right time. I ran the exact same query in SQL Management Studio and it returned the correct date. Is there a time culture or something set somewhere in one identity that might be affecting this?
Thanks