Search: smalldatetime

More Results

Sort by: Relevance | Date

  • Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005

    Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In this tip, you'll learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP... Tip   |   SearchSQLServer.com

  • Return only the date from a SQL smalldatetime field

    The following question and answer appeared in our ITKnowledge Exchange discussion forums: Return only the date part of a... ITKnowledge Exchange Memb   |   SearchSQLServer.com

  • Top 10 SQL Server development tips of 2008

    Here are the top 10 most viewed SQL Server development tips of 2008. From converting date/time values into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL... The Year in Review   |   SearchSQLServer.com

  • Top 10 SQL Server Tips of 2008

    Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most... The Year in Review   |   SearchSQLServer.com

  • Using SQL Server datetime functions GETDATE, DATENAME and DATEPART

    Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the day, month or year from a datetime... Tip   |   SearchSQLServer.com

  • Getting the exact time from a query

    If you're hoping to get seconds accuracy from a query using smalldatetime, you're out of luck. Expert Adam Mechanic offers another solution in this expert response. Ask the Expert   |   SearchSQLServer.com

  • Using T-SQL data types in SQL Server 2008

    Data Types

    All the data values of a column must be of the same data type. (The only exception specifies the values of the SQL_VARIANT data type.) Transact-SQL uses different data types, which can be categorized as... Book Excerpt   |   SearchSQLServer.com

  • Tutorial: Learn SQL Server basics from A-Z

      As SQL Server continues to evolve, newbies and sometimes even the most knowledgeable DBAs could use a little help. Whether you want to learn SQL Server basics or simply get a refresher, we've got what you're... Tutorial   |   SearchSQLServer.com

  • Using DATEADD and DATEDIFF to calculate SQL Server datetime values

    In a SQL Server database, DATETIME and SMALLDATETIME values are stored as integers. However, unlike integers, you cannot simply use mathematical expressions to perform calculations on these values. Even so, there might be times when you want to... Tip   |   SearchSQLServer.com

  • SQL Server data conversions from date/time values to character types

    In this article, I explain how to convert DATETIME and SMALLDATETIME data types to character data and how character data can be converted to date/time data. Specifically, the article describes how Transact-SQL supports two built-in functions for... Tip   |   SearchSQLServer.com

Search Again: