Microsoft SQL Server
- Getting started with Microsoft SQL Server
- Awesome Book
- Awesome Community
- Awesome Course
- Awesome Tutorial
- Awesome YouTube
- Advanced options
- Aggregate Functions
- Alias Names in Sql Server
- Analyzing a Query
- Backup and Restore Database
- Basic DDL Operations in MS SQL Server
- bcp (bulk copy program) Utility
- BULK Import
- CASE Statement
- CLUSTERED COLUMNSTORE
- COALESCE
- Common Language Runtime Integration
- Common Table Expressions
- Computed Columns
- Converting data types
- CREATE VIEW
- cross apply
- Cursors
- Data Types
- Database permissions
- Database Snapshots
- Dates
- Create function to calculate a person's age on a specific date
- CROSS PLATFORM DATE OBJECT
- Date & Time Formatting using CONVERT
- Date & Time Formatting using FORMAT
- Date Format Extended
- Date parts reference
- DATEADD for adding and subtracting time periods
- DATEDIFF for calculating time period differences
- DATEPART & DATENAME
- Get the current DateTime
- Getting the last day of a month
- Return just Date from a DateTime
- DBCC
- DBMAIL
- Delimiting special characters and reserved words
- Drop Keyword
- Dynamic data masking
- Dynamic SQL
- Dynamic SQL Pivot
- Encryption
- Export data in txt file by using SQLCMD
- File Group
- Filestream
- FOR JSON
- FOR XML PATH
- Foreign Keys
- Full-Text Indexing
- Generating a range of dates
- GROUP BY
- IF...ELSE
- Index
- In-Memory OLTP (Hekaton)
- Insert
- INSERT INTO
- Installing SQL Server on Windows
- Isolation levels and locking
- Join
- JSON in Sql Server
- Last Inserted Identity
- Limit Result Set
- Logical Functions
- Managing Azure SQL Database
- MERGE
- Microsoft SQL Server Management Studio Shortcut Keys
- Migration
- Modify JSON text
- Move and copy data around tables
- Natively compiled modules (Hekaton)
- NULLs
- OPENJSON
- ORDER BY
- OVER Clause
- Pagination
- Parsename
- Partitioning
- Permissions and Security
- PHANTOM read
- PIVOT / UNPIVOT
- Primary Keys
- Privileges or Permissions
- Queries with JSON data
- Query Hints
- Query Store
- Querying results by page
- Ranking Functions
- Resource Governor
- Retrieve information about the database
- Retrieve Information about your Instance
- Row-level security
- Scheduled Task or Job
- Schemas
- SCOPE_IDENTITY()
- SELECT statement
- Sequences
- Service broker
- Sorting/ordering rows
- Spatial Data
- Split String function in Sql Server
- SQL Server Evolution through different versions (2000 - 2016)
- SQL Server Management Studio (SSMS)
- SQLCMD
- Stored Procedures
- Storing JSON in SQL tables
- String Aggregate functions in SQL Server
- String Functions
- Subqueries
- System database - TempDb
- Table Valued Parameters
- Temporal Tables
- The STUFF Function
- Transaction handling
- Transaction isolation levels
- Trigger
- TRY/CATCH
- UNION
- Use of TEMP Table
- User Defined Table Types
- Variables
- Views
- WHILE loop
- Window functions
- With Ties Option
Microsoft SQL Server Dates
Syntax
- EOMONTH (start_date [, month_to_add ] )
Remarks
as per https://msdn.microsoft.com/en-us/library/ms187819.aspx, DateTimes are only precise to 3ms.
Rounding of datetime Fractional Second Precision datetime values are rounded to increments of .000, .003, or .007 seconds, as shown in the following table.
| User-specified value | System stored value |
|---|---|
| 01/01/98 23:59:59.999 | 1998-01-02 00:00:00.000 |
| ------ | ------ |
| 01/01/98 23:59:59.995 | 1998-01-01 23:59:59.997 |
| 01/01/98 23:59:59.996 | |
| 01/01/98 23:59:59.997 | |
| 01/01/98 23:59:59.998 | |
| ------ | ------ |
| 01/01/98 23:59:59.992 | 1998-01-01 23:59:59.993 |
| 01/01/98 23:59:59.993 | |
| 01/01/98 23:59:59.994 | |
| ------ | ------ |
| 01/01/98 23:59:59.990 | 1998-01-01 23:59:59.990 |
| 01/01/98 23:59:59.991 | |
| ------ | ------ |
If more precision is required, time, datetime2 or datetimeoffset should be used.
Dates Related Examples
- Create function to calculate a person's age on a specific date
- CROSS PLATFORM DATE OBJECT
- Date & Time Formatting using CONVERT
- Date & Time Formatting using FORMAT
- Date Format Extended
- Date parts reference
- DATEADD for adding and subtracting time periods
- DATEDIFF for calculating time period differences
- DATEPART & DATENAME
- Get the current DateTime
- Getting the last day of a month
- Return just Date from a DateTime
