<div>
I assume that 12 PM means at lunch time, not at midnight...<br />
<br />
set @rundate = getdate()<br />
set @startdate = dateadd(hour, -12, convert(datetime, convert(varchar(10), @rundate, 120), 120))<br />
set @enddate = dateadd(day, 1, @startdate )<br />
<br />

</div>


I assume that 12 PM means at lunch time, not at midnight...

set @rundate = getdate()
set @startdate = dateadd(hour, -12, convert(datetime, convert(varchar(10), @rundate, 120), 120))
set @enddate = dateadd(day, 1, @startdate )



<div>
Yes, 12 PM is Noon. <br />
<br />
Tried is and I get no results. ?? 
</div>


Yes, 12 PM is Noon.

Tried is and I get no results. ??

<div>
select @today = convert(varchar(10),getdat<wbr />e(),120),<br />
@startDate &nbsp; = &nbsp;CAST(convert(varchar(10),g<wbr />etdate(),1<wbr />20)+' 12:00:00' as datetime) -1 ,<br />
@endDate &nbsp; &nbsp;= CAST(convert(varchar(10),g<wbr />etdate(),1<wbr />20)+' 12:00:00' as datetime)<br />

</div>


select @today = convert(varchar(10),getdate(),120),
@startDate   =  CAST(convert(varchar(10),getdate(),120)+' 12:00:00' as datetime) -1 ,
@endDate    = CAST(convert(varchar(10),getdate(),120)+' 12:00:00' as datetime)


<div>
ok. &nbsp;that last one works. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I have a query in SQL server 2005 that I run every day. &nbsp;Can I change the values below to pull the date from the system rather than having to change them each day?<br />
<br />
set @rundate = '2006-04-21' &nbsp; -- &nbsp;Today<br />
set @startdate = '2006-04-20 12:00:00' &nbsp;--Yesterday 12 PM<br />
set @enddate = '2006-04-20 12:00:00' &nbsp;--Today 12 PM<br />
<br />
The Start and End dates have to use 12:00 PM<br />
<br />
Can I use the GetDate function to set this up??<br />
<br />
Please help as this is urgent.<br />
<br />
Scotto13
</div>
</div>


I have a query in SQL server 2005 that I run every day.  Can I change the values below to pull the date from the system rather than having to change them each day?

set @rundate = '2006-04-21'   --  Today
set @startdate = '2006-04-20 12:00:00'  --Yesterday 12 PM
set @enddate = '2006-04-20 12:00:00'  --Today 12 PM

The Start and End dates have to use 12:00 PM

Can I use the GetDate function to set this up??

Please help as this is urgent.

Scotto13

GetDate??

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.