Darren J. McLeod
B.Sc., MCSD, Senior Consultant, TMC,
Regina, SK Canada
Register
Login
September 09, 2010
Home
About Me
Blog Archive
Archive
<
September 2010
>
Sun
Mon
Tue
Wed
Thu
Fri
Sat
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
Monthly
September, 2009
August, 2009
May, 2009
April, 2009
January, 2009
September, 2008
August, 2008
July, 2008
June, 2008
May, 2008
April, 2008
March, 2008
February, 2008
January, 2008
December, 2007
November, 2007
October, 2007
Search Blog
All Blogs
Darren J. McLeod
Keywords
Phrase
Blog List
View All Recent Entries
Darren J. McLeod
Contact Me
Email:
Name:
Subject:
Message:
Security Code
Enter the code shown above in the box below
Send
Announcements
Recommended Websites
DevExpress - VB.NET Refactor
irritatedVowel - .Net Naming/Programming Standards
DEVELOPERfusion - Convert C# to VB.NET
Dynamic Drive- FavIcon Generator
Events
Event Start
Event End
Title
Recommended Reading
Most recent blog entries
How to check if a datetime field equals current date in SQL Server Transact SQL
Jan
13
Written by:
Darren McLeod
Tuesday, January 13, 2009 9:21 AM
Had to write a SQL Server query to check if a date is the current day. After some searching I found a good way of doing it here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38012
SELECT * FROM table WHERE DATEDIFF(day, StartDate, GETDATE()) = 0
Tags:
0 comment(s) so far...
Your name:
Your email:
(Optional) Email used only to show
Gravatar
.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment
Cancel