Hi everyone,
I need to substract one day from de system date(yesterday).
example:
execute spGetCustomers GetDate()-1,null,null --system date less one day(yesterday)
Can someone tell what is the SQL sintax to do that.
Thank's
Sql date substract question
Hot Topic
- Unable to set Default Schema for a group
- Cannot connect to Sql Express via ASP.NET after I attached and detached my db to sql management studio
- Aggregation Design Wizard hangs after Count
- Connection failed!
- NOT EXISTS optimization
- SQL Server 2005 June CTP Install Issue
- Unable to select a Single Provider in Web Site Admin Tool
- CTE and UNION Queries
- Change Data Capture
- Convert SQL 2005 to SQL 2000
SQL Server
- ODBC connection failing on 64 version of Windows 2003 server
- New CTP
- Error when calling a Sub report (Jump to report)
- MonthName Chart Problem
- Schema changes after Replication
- ANN:Dundas Chart for Reporting Services now in Beta
- Function with CASE Statements
- Full-text indexing backup and mirroring
- How to download the english version of SQL Sever Express?
- Create DTS Package in SQL server 2005 (Ver:9.0.1116).
Sql date substract question
Vincent Randal
snakey_tv
You will need to store the value in a variable as you can't use expressions in stored procedure calls.
so
declare @yesterday datetime
set @yesterday = getdate()-1 --or set @yesterday = dateadd(d,-1,getdate())
exec sp_MySP @yesterday,.....
Remember that getdate() includes the time so adding -1 will result in a data with the same time as now but a day ago. It won't be the start of yesterday.
GUYO
Hey,
Your example itself is right !! you can use getdate().
anyways, this is the syntax.
dateadd(dd, -1, getdate())
Amarnath