Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 OrderDate = Today Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, February 22, 2013 6:49 AM
 Old Hand Group: General Forum Members Last Login: Today @ 12:59 PM Points: 368, Visits: 739
 How to make code below working? (OrderDate is date type)I want to add some code if OrderDate is todayif (select OrderDate from Order) = CONVERT(VARCHAR(20), Getdate(), 101)Begin...some code...End
Post #1423031
 Posted Friday, February 22, 2013 6:54 AM
 Valued Member Group: General Forum Members Last Login: Sunday, November 20, 2016 11:57 PM Points: 61, Visits: 613
 Please check this code:`if exists (select OrderDate from Order) = CONVERT(VARCHAR(20), Getdate(), 101)Begin...some code...End`
Post #1423038
 Posted Friday, February 22, 2013 7:08 AM
 SSCrazy Group: General Forum Members Last Login: Today @ 7:32 AM Points: 2,754, Visits: 5,197
 if exists (select OrderDate from Order where OrderDate = CAST(Getdate() AS DATE))Begin...some code...EndNote with this code, the if check will evaluate to true if any value of OrderDate in the table is today - is that the desired behaviour?CheersGaz
Post #1423046
 Posted Friday, February 22, 2013 8:56 AM
 SSC-Addicted Group: General Forum Members Last Login: Yesterday @ 2:41 AM Points: 444, Visits: 2,158
 `DECLARE @TODAY DATETIME = CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),126))SELECT @TODAYDECLARE @TOMORROW DATETIME = @TODAY+1---- Alternative-- DECLARE @TOMORROW DATETIME = DATEADD(DD,1,@TODAY)-- DECLARE @TOMORROW DATETIME = DATEADD(HH,24,@TODAY)--SELECT @TOMORROWSELECT * FROM TheTable WHERE TheDate >= @TODAY AND TheDate < @TOMORROW`Or something similar to this. Because time is a continuous and you do not want to depend on granulaty of the storage system, you want to check from a beginning time where the time is included up to a end time where the time is excluded.Why?In this way it does not matter if you express your time in months, weeks, days, hours, minutes etc.For example if you want to check for an half an hour, you check for the greater or equal to the begin time and less then the begintime plus 30 minutes.Do not try to create an endtime which is included, because this is very type dependend. For a day the last endtime which is stored in datetime format is 23:59:59.997. But for other formats it is different. While the next day 00:00:00 is available in all storage types (I strongly hope )(For shortdatetime it is 23:59:59 Me thinks).ben brugman
Post #1423110

 Permissions