How to manipulating date in SQL || How to format date in SQL Server || SQL

Опубликовано: 24 Октябрь 2024
на канале: rejawebs

918

‪@rejawebs‬ ‪@MSSQLDBAsLife‬ ‪@SQLServerGeeks‬ ‪@SQL‬ ‪@sqlbelle‬
#sql #sqltutorial #sqlquery #date #database #databasedevelopment
-- Get CURRENT DATE
SELECT GETDATE() AS CurrentDate
-- Cast as Only Date
SELECT CAST(GETDATE() AS DATE) CurrentDate
-- Cast as Only Date
SELECT CAST(GETDATE() AS DATE) CurrentDate
SELECT CAST(GETDATE() AS DATETIME) CurrentDate
--Convert as Only Date and Date time
SELECT CONVERT(DATE, GETDATE()) CurrentDate
SELECT CONVERT(DATETIME, GETDATE()) CurrentDateTime
--Convert into NVARCHAR AND Format it into 'mon dd yyyy hh:miAM/PM'
SELECT CONVERT(NVARCHAR, GETDATE(), 100);
--Get mm/dd/yyyy format
SELECT CONVERT(NVARCHAR, GETDATE(), 101);
--Get 24 hours time only
SELECT CONVERT(NVARCHAR, GETDATE(), 108);
--SQL Format Function in 12 hours like MM/dd/yyyy hh:mm:ss tt
SELECT FORMAT(GETDATE(), 'MM/dd/yyyy hh:mm:ss tt') AS CurrentTime
--SQL Format Function in 12 hours hour-min format
SELECT FORMAT(GETDATE(), 'hh:mm tt') AS CurrentTime
--SQL Format Function 24 hours like MM/dd/yyyy HH:mm:ss
SELECT FORMAT(GETDATE(), 'MM/dd/yyyy hh:mm:ss') AS CurrentTime
--SQL Format Function in 24 hours hour-min format
SELECT FORMAT(GETDATE(), 'HH:mm') AS CurrentTime
--Get date difference in year
SELECT DATEDIFF(YEAR, '11/24/2015','09/28/2019') AS DateDiff;
--Get date difference in month
SELECT DATEDIFF(MONTH, '11/24/2015','09/28/2019') AS DateDiff;
--Get date difference in minute
SELECT DATEDIFF(MINUTE, '11/24/2015','09/28/2019') AS DateDiff;
--Get date difference in second
SELECT DATEDIFF(SECOND, '11/24/2015','09/28/2019') AS DateDiff;
--Get date difference in mili second
SELECT DATEDIFF(MILLISECOND, '11/24/2015','09/28/2019') AS DateDiff;
--Use of DATENAME function
--for year
SELECT DATENAME(YEAR, '12/16/2019') AS DatePartString;
--for month
SELECT DATENAME(MONTH, '12/16/2019') AS DatePartString;
--for day
SELECT DATENAME(DAY, '12/16/2019') AS DatePartString;
--for hour
SELECT DATENAME(HOUR, '12/16/2019 10:15 PM') AS DatePartString;
--for MIN
SELECT DATENAME(MINUTE, '12/16/2019 10:15 PM') AS DatePartString;
--To get day of year
SELECT DATENAME(DAYOFYEAR, '12/16/2019 10:15 PM') AS DatePartString;
--Day Function
SELECT DAY('12/16/2019 10:15 PM') AS DayOfMonth;
--DATEADD() function
--DATEADD(interval, number, date)
SELECT DATEADD(YEAR, 1, '12/16/2019') AS DateAdd;
--Check if the expression is a valid date:
SELECT ISDATE('2017-08-25');

TOPICS:
What is date manipulation in SQL?,
How to manipulate data in SQL?,
How do I customize the date in SQL?,
How to perform date calculations in SQL?,
SQL Server Tutorial: Date manipulation,
Introduction to SQL Server - Date Functions,
Working With SQL Server Dates | Format Function,
How to Format Dates in SQL Server using Convert and Format,
DateTime functions in SQL Server,
SQL Convert Date functions and formats,
Common Date Manipulations on Data Science SQL,
SQL Server DATETIME, DATE and TIME data types,
Convert numbers year, month and days and more to dates,
SQL Tutorial - 45: Date & Time Functions,
date functions in sql with examples,
sql where date = specific date,
format date function sql,
sql date functions,
how to insert date in sql query,
date scenarios in sql,
how to pass date in sql query,
sql where date = today,
sql date conversion | Convert Date format into DD/MM/YYYY format in SQL Server
The FORMAT function in SQL Server - extracting single or multiple parts of a datetime
How to Change Format of Date in SQL SERVER query | By SYED I.T SOLUTIONS © | Urdu
Format Date in SQL Query within SQL Server Management Studio.
How to Format Dates in SQL Server using Convert and Format
How to Solve any SQL Query related to Date Formatting | sql interview questions and answers
SQL Tutorial Part 11 | SQL Date Functions and Diff Date Formats | Convert From YY-MM-DD to DD-MM-YYY
SQL Server DATETIME, DATE and TIME data types | Manipulating Dates, times and Strings | SQL basics
Convert Text to Date Values in Excel - Multiple Examples
SQL server tutorial: How to extract only date with all formats from datetime field in sql server
SQL Tutorial #29 - Date and Time Functions in SQL
How to get DATE from DATETIME in SQL
How to get MONTH from DATE in SQL
SQL Server - How To Convert Datetime To Integer
How to Return Date Part Only from a SQL Server Datetime datatype
How to change date formate from YYYYMMDD to DDMMYYYY in SQL SERVER 2012?
How To Convert Default Format Date Styles In SQL Server
SQL date format: Converting yyyy mm dd to dd mm yyyy Easily | sql convert date
How can get Month, day and year from date field in SQL server
How To Extract YEAR, MONTH, DAY From A Date Column In MS SQL Server
DateTime functions like GETDATE, DATEADD, CONVERT,FORMAT,CAST in SQL Server
27-Date & Time Functions in SQL | Types of SQL Functions| Examples | DATE_FORMAT(), DATE_ADD()
Format Date DateTime ISO Format 📚
SQL Server - Formatting a Date
How to format a date in SQL Server?
How do I change the date format in sql?
How to convert any date format to yyyy-mm-dd in SQL Server?