Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

How to search for date and time values using Microsoft SQL Server 2000


 Article Abstract:

Because of the way date and time values are stored in SQL Server, searching for a particular date or time isn’t as straightforward as you might think it would be. This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval, and how to query date/time data to get the right results every time.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Modeling Date Logic I: Date Arithmetic, Date and Time Datatypes, Date Formats, & Built-in Functions
Webcast Q&A Transcript: Reporting Services Launch (Part II)
Integrating SQL LiteSpeed in your existing Backup Infrastructure
Known SQL Server service packs problems
Troubleshooting SQL Server Upgrade Wizard
Troubleshooting SQL Server Command Prompt Utilities
Determining whether your version of SQL Server and MSDE is vulnerable to Slammer...
A Date with DB2
Troubleshooting SQL Server 2005 Management Studio
SQL Server Profiler Optimization Tips



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004