Dynamic StartDate and Todays Date in SQL

I have a Stored Procedure that takes Start Date and End Dates. So the Start Date must start from 1/1/2018. I want to make the Start Date as Dynamic- meaning when we are in 2019, the start Date will pick up 1/1/2019 and End Date is always Today's date. I appreciate for any help.

StartDate: 1/1/2018
EndDate: TodaysDate

Thanks

John

출처 sql

Which dbms are you using? Show us your current code attempt. - jarlh
You need to add the DBMS you're using : SQL Server, Oracle, MySQL etc... - CodeNotFound
Possible duplicate of Getting the current date in SQL Server? - mjwills
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using postgresql, oracle, sql-server, db2, ... - a_horse_with_no_name

1 답변

you can get it in sql itself like this

SELECT
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS StartOfYear,
   GETDATE() AS Today

Does GETDATE include time? - mjwills
I think it depends a lot from the DBMS :) - CodeNotFound
No, it does not include time. But I want to hold the start date in a variable and use that variable in every startdate in the body of SP instead of using Static Date. - John
No, it does not include time. GETDATE does include time. - mjwills

Dynamic StartDate and Todays Date in SQL

1 답변

Linked

Related

Latest