Tag: getdate

Query to return all values from next month

dateadd getdate reporting-services sql sql-server

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

azure-sql-database getdate sql

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

SQL – Select records for the same day between particular data range [closed]

datetime getdate sql sql-server

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions concerning problems with code you’ve written must describe the specific problem — and include valid code to reproduce it — in the question itself. See SSCCE.org for guidance. Closed 8 years ago. Improve this question I need to check the SQL date range between