How to search for date and time values using MS SQL

Tutorials Shared by the Internet Community

Advertisements


Synopsis

This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval.

Statistics

  • Total Hits - 27025

  • Total Votes - 120 votes

  • Vote Up - 52 votes

  • Vote Down - 68 votes

  • Domain - www.codebeach.com

  • Category - MsSQL/MsSQL Misc

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 00:59:04

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. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements