How to search for date and time values using MS SQL
Advertisements
| Top Tutorials | New Tutorials | Submit | Login | Register |
Tutorial Detail
How to search for date and time values using MS SQL
This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval.http://www.codebeach.com/tutorials/murach-search-date-time-microsoft-sql-server.asp
Total Hits: 4960
- Average Rating :
Total Votes: 40 votes
Category: MsSQL/MsSQL Misc
Submitted on: 2008-04-15 00:59:04
Submitted By: Shekhar
Description:
Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored. SQL Server supports two date/time data types: datetime and smalldatetime. The difference between the two is the amount of storage used. More detail...Rating Detail
| Stars | Percentage | Total Vote |
|---|---|---|
| |
   20% |
8 |
| |
   15% |
6 |
| |
   15% |
6 |
| |
   15% |
6 |
| |
   20% |
8 |