SQL Tutorial
5. 图瓦卢
Selected Reading
- SQL - Discussion
- SQL - Useful Resources
- SQL - Useful Functions
- SQL - Quick Guide
- SQL - Questions and Answers
- SQL - Datatype Functions
- SQL - Conversion Functions
- SQL - JSON Functions
- SQL - Cursor Functions
- SQL - Logical Functions
- SQL - Statistical Functions
- SQL - Text & Image Functions
- SQL - Numeric Functions
- SQL - Aggregate Functions
- SQL - String Functions
- SQL - Date Functions
- SQL - Database Tuning
- SQL - IN vs EXISTS
- SQL - Group By vs Order By
- SQL - Common Table Expression
- SQL - Cursors
- SQL - Date & Time
- SQL - Auto Increment
- SQL - Using Sequences
- SQL - Handling Duplicates
- SQL - Sub Queries
- SQL - Transactions
- SQL - NULL Values
- SQL - Stored Procedures
- SQL - Default Constraint
- SQL - Check Constraint
- SQL - Null Functions
- SQL - Min & Max
- SQL - Hosting
- SQL - Injection
- SQL - Comments
- SQL - Wildcards
- SQL - Non-Clustered Index
- SQL - Clustered Index
- SQL - Unique Index
- SQL - Primary Key
- - 工会诉Join
- SQL - Inner Join
- SQL - Using Joins
- SQL - Aliases
- SQL - EXCEPT Operator
- SQL - INTERSECT Operator
- SQL - UNION vs UNION ALL
- SQL - UNION Operator
- SQL - BETWEEN Operator
- SQL - NOT NULL
- SQL - IS NOT NULL
- SQL - IS NULL
- SQL - NOT EQUAL
- SQL - NOT Operator
- SQL - CASE
- SQL - EXISTS Operator
- SQL - ANY, ALL Operators
- SQL - IN Operator
- SQL - LIKE Operator
- SQL - BOOLEAN (BIT) Operator
- SQL - AND & OR
- SQL - Having Clause
- SQL - Group By Clause
- SQL - Order By Clause
- SQL - Distinct Clause
- SQL - Top Clause
- SQL - Where Clause
- SQL - Rename Views
- SQL - Drop Views
- SQL - Update Views
- SQL - Create Views
- SQL - Sorting Results
- SQL - Delete Query
- SQL - Update Query
- SQL - Insert Into Select
- SQL - Select Into
- SQL - Select Query
- SQL - Insert Query
- SQL - Constraints
- SQL - Delete Table
- SQL - Drop Table
- SQL - Alter Tables
- SQL - Temporary Tables
- SQL - Clone Tables
- SQL - Truncate Table
- SQL - Rename Table
- SQL - Show Tables
- SQL - Create Table
- SQL - Backup Database
- SQL - Show Database
- SQL - Rename Database
- SQL - Select Database
- SQL - Drop Database
- SQL - Create Database
- SQL - Expressions
- SQL - Operators
- SQL - Data Types
- SQL - Syntax
- SQL - Databases
- SQL - RDBMS Concepts
- SQL - Overview
- SQL - Home
5. 图瓦卢
- 页: 1
- 页: 1
- 结构-创建指数
- 页: 1
- 页: 1
- 页: 1
- SQL - Foreign Key
- 文 件
- ∗ E/CN.6/2009/1。
- 页: 1
- 页: 1
- 文 件
- 页: 1
- 页: 1
- 文 件
- 页: 1
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
SQL - Date Functions
SQL - Date Functions
The Date & time functions are built-in functions in the SQL server that allows you to manipulate and perform operations on date and time values in the SQL server.
These functions can be used in SQL Server queries to perform various date and time operations, such as filtering records based on dates, calculating date differences, and formatting dates for display purposes.
| Sr.No. | Function & Description |
|---|---|
| 1 |
This function is used to retrieve the first day of the week which is set by the SET DATEFIRST function. |
| 2 |
Is used to retrieve the current date and time. |
| 3 |
This function is used to retrieve the current time zone offset from Coordinated Universal Time (UTC). |
| 4 |
Is used to retrieve the current time zone ID observed by a server or an instance. |
| 5 |
Is used to group data into groups that correspond to fixed periods of time. |
| 6 |
Is used to add a specific number of intervals to a given date or time value. |
| 7 |
Is used to calculate the difference between two date values and returns in a int data type. |
| 8 |
Is used to calculate the difference between two dates values and return in a bigint data type. |
| 9 |
This function is used to retrieve a date from inspanidual segments such as year, month, and day. |
| 10 |
This function is used to retrieve a specified part of a date or time value as string. |
| 11 |
Is used to return a specified part of a date or time value as integer. |
| 12 |
Is used to construct a datetime2 value from an inspanidual date and time segments. |
| 13 |
Is used to construct a datetime value from an inspanidual date and time segments. |
| 14 |
Is used to extract a datetimeoffset value from each of a date s component parts. |
| 15 |
Is used to truncate a date or time value to a specified datepart (such as year, month, day, etc.). |
| 16 |
This function is used to get the day of the month for a specified date. |
| 17 |
This function is used to get the last day of the month for a specified date value. |
| 18 |
This function is used to get the current database system date and time. |
| 19 |
This function is used to get the current database system UTC date and time. |
| 20 |
Is used to determine whether a value is a vapd date or not. |
| 21 |
This function is used to get the month part for a specified date (value can be from 1 to 12). |
| 22 |
Is used to construct a new datetime value from inspanidual segments (such as year, month, etc.). |
| 23 |
This function is used to get datetimeoffset values that has been changed from the stored time zone offset to a given new time zone offset. |
| 24 |
This function is used to get the date and time of the SQL Server. |
| 25 |
This function is used to get a value of DATETIMEOFFSET(7) that provides the current system date and time and also timezone of the SQL server. |
| 26 |
This function is used to get date and time of the computer on which the instance of SQL Server is running. |
| 27 |
Is used to construct a time value from inspanidual segments. |
| 28 |
This function is used to get a datetimeoffset value that is translated from a datetime2 expression. |
| 29 |
This function is used to get an integer number that represents the year of the given date. |