Skip to content
Advertisement

Tag: getdate

Query to return all values from next month

I have a dataset of subscriptions in a table that looks something like this: Table: UserID Subscription_type Subscription_end_date I’m trying to build a report in SSRS that shows a list of all subscriptions that are going to expire somewhere in the next month. The report gets sent on the first of every month and needs to show all the rows

SQL GetDate() returns wrong time

I am having an issue while using GetDate(), for some reason is not returning the right time (it is 7 hours ahead from the actual time) I am using AZURE and the Database is configured with the right location (West US). I will appreciate any help! I tried to run this script: Answer Azure SQL Databases are always UTC, regardless

Advertisement