際際滷

際際滷Share a Scribd company logo
DATE AND TIME FUNCTIONS
 The datetime datatypes are DATE, TIMESTAMP, TIMESTAMP WITH
TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. Values of
datetime datatypes are sometimes called datetimes.
 The interval datatypes are INTERVAL YEAR TO MONTH and
INTERVAL DAY TO SECOND. Values of interval datatypes are
sometimes called intervals.
 YEAR
 MONTH
 DAY
 HOUR
 MINUTE
 SECOND
 DATE - format YYYY-MM-DD
 DATETIME - format: YYYY-MM-DD HH:MI:SS
 TIMESTAMP - format: YYYY-MM-DD HH:MI:SS
 YEAR - format YYYY or YY
 SELECT *
 FROM Orders
 WHERE OrderDate='2019-11-11'
Ad

Recommended

Glass building
Glass building
Pure Presentations
3D Leadership
3D Leadership
Pure Presentations
Polaroid
Polaroid
Pure Presentations
On target
On target
Pure Presentations
Wind turbines
Wind turbines
Pure Presentations
Financial recovery
Financial recovery
Pure Presentations
Sacre coeur
Sacre coeur
Pure Presentations
Abstract halftone
Abstract halftone
Pure Presentations
Airplane take off landing
Airplane take off landing
Pure Presentations
Medical bright circles
Medical bright circles
Pure Presentations
Spices
Spices
Pure Presentations
Union Jack UK
Union Jack UK
Pure Presentations
USB World
USB World
Pure Presentations
Sunny meadow
Sunny meadow
Pure Presentations
Business presentation
Business presentation
Pure Presentations
SOFTWARE TESTING CHAPTER 8 SE
SOFTWARE TESTING CHAPTER 8 SE
Abrar ali
SOFTWRE REQUIREMNETS SE
SOFTWRE REQUIREMNETS SE
Abrar ali
SE CHAPTER 2 PROCESS MODELS
SE CHAPTER 2 PROCESS MODELS
Abrar ali
AGILE VS Scrum
AGILE VS Scrum
Abrar ali
SE CHAPTER 1 SOFTWARE ENGINEERING
SE CHAPTER 1 SOFTWARE ENGINEERING
Abrar ali
Sql FUNCTIONS
Sql FUNCTIONS
Abrar ali
Database COMPLETE
Database COMPLETE
Abrar ali
Dbms oracle
Dbms oracle
Abrar ali
Quicksort ALGORITHM
Quicksort ALGORITHM
Abrar ali
Joining
Joining
Abrar ali
Greedy algorithm
Greedy algorithm
Abrar ali
Constraints
Constraints
Abrar ali
DML DATA MAINUPULATION LANGUAGE
DML DATA MAINUPULATION LANGUAGE
Abrar ali
DDL DATA DEFINATION LANGUAGE
DDL DATA DEFINATION LANGUAGE
Abrar ali
Java
Java
Abrar ali

More Related Content

What's hot (7)

Airplane take off landing
Airplane take off landing
Pure Presentations
Medical bright circles
Medical bright circles
Pure Presentations
Spices
Spices
Pure Presentations
Union Jack UK
Union Jack UK
Pure Presentations
USB World
USB World
Pure Presentations
Sunny meadow
Sunny meadow
Pure Presentations
Business presentation
Business presentation
Pure Presentations

More from Abrar ali (17)

SOFTWARE TESTING CHAPTER 8 SE
SOFTWARE TESTING CHAPTER 8 SE
Abrar ali
SOFTWRE REQUIREMNETS SE
SOFTWRE REQUIREMNETS SE
Abrar ali
SE CHAPTER 2 PROCESS MODELS
SE CHAPTER 2 PROCESS MODELS
Abrar ali
AGILE VS Scrum
AGILE VS Scrum
Abrar ali
SE CHAPTER 1 SOFTWARE ENGINEERING
SE CHAPTER 1 SOFTWARE ENGINEERING
Abrar ali
Sql FUNCTIONS
Sql FUNCTIONS
Abrar ali
Database COMPLETE
Database COMPLETE
Abrar ali
Dbms oracle
Dbms oracle
Abrar ali
Quicksort ALGORITHM
Quicksort ALGORITHM
Abrar ali
Joining
Joining
Abrar ali
Greedy algorithm
Greedy algorithm
Abrar ali
Constraints
Constraints
Abrar ali
DML DATA MAINUPULATION LANGUAGE
DML DATA MAINUPULATION LANGUAGE
Abrar ali
DDL DATA DEFINATION LANGUAGE
DDL DATA DEFINATION LANGUAGE
Abrar ali
Java
Java
Abrar ali
Weka presentation
Weka presentation
Abrar ali
Machine learning
Machine learning
Abrar ali
SOFTWARE TESTING CHAPTER 8 SE
SOFTWARE TESTING CHAPTER 8 SE
Abrar ali
SOFTWRE REQUIREMNETS SE
SOFTWRE REQUIREMNETS SE
Abrar ali
SE CHAPTER 2 PROCESS MODELS
SE CHAPTER 2 PROCESS MODELS
Abrar ali
AGILE VS Scrum
AGILE VS Scrum
Abrar ali
SE CHAPTER 1 SOFTWARE ENGINEERING
SE CHAPTER 1 SOFTWARE ENGINEERING
Abrar ali
Sql FUNCTIONS
Sql FUNCTIONS
Abrar ali
Database COMPLETE
Database COMPLETE
Abrar ali
Dbms oracle
Dbms oracle
Abrar ali
Quicksort ALGORITHM
Quicksort ALGORITHM
Abrar ali
Greedy algorithm
Greedy algorithm
Abrar ali
Constraints
Constraints
Abrar ali
DML DATA MAINUPULATION LANGUAGE
DML DATA MAINUPULATION LANGUAGE
Abrar ali
DDL DATA DEFINATION LANGUAGE
DDL DATA DEFINATION LANGUAGE
Abrar ali
Weka presentation
Weka presentation
Abrar ali
Machine learning
Machine learning
Abrar ali
Ad

Recently uploaded (15)

Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37
Briefing on the upcoming UNFSS +4 Stocktake
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
AC_Manufacturer_Strategy_Commercial_Government.pptx
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
FL Studio Crack Full Version [Latest 2025]
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
2025-06-22 Abraham 04 (shared slides).pptx
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
lukmanjavalatte
Pitch deck for any business presentation.pptx
Pitch deck for any business presentation.pptx
mukeshpurohit991
Heating_Effect_of_Solar_Corona_Presentation.pptx
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
Section 4 - Islamic Civilization & Culture.pptx
Section 4 - Islamic Civilization & Culture.pptx
MianMuhammadUbaidUll
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
Political Polarization And Government Accountability.pptx
Political Polarization And Government Accountability.pptx
EverlyseLumantas
PEN TO PODIUM powerpoint presentation.pptx
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
Josaya - Abstract for the research of the youth development.pdf
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
Joy In The Journey 06 22 2025.pptx
Joy In The Journey 06 22 2025.pptx
FamilyWorshipCenterD
Bob Stewart Acts 18 06 18 2025.pptx
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Google Algorithm Updates A Complete Guide for Digital Marketing Students.pdf
Nithinks37
Briefing on the upcoming UNFSS +4 Stocktake
Briefing on the upcoming UNFSS +4 Stocktake
Francois Stepman
AC_Manufacturer_Strategy_Commercial_Government.pptx
AC_Manufacturer_Strategy_Commercial_Government.pptx
ajajsain
FL Studio Crack Full Version [Latest 2025]
FL Studio Crack Full Version [Latest 2025]
Jackson lithms
2025-06-22 Abraham 04 (shared slides).pptx
2025-06-22 Abraham 04 (shared slides).pptx
Dale Wells
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
Itinerary ROHIS SMUNIC diperlukan untuk acara.pptx
lukmanjavalatte
Pitch deck for any business presentation.pptx
Pitch deck for any business presentation.pptx
mukeshpurohit991
Heating_Effect_of_Solar_Corona_Presentation.pptx
Heating_Effect_of_Solar_Corona_Presentation.pptx
Hanumamshukla
Section 4 - Islamic Civilization & Culture.pptx
Section 4 - Islamic Civilization & Culture.pptx
MianMuhammadUbaidUll
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Japan's Media and Telecom Markets: Evolution, Global Competition, and NTT Law...
Toshiya Jitsuzumi
Political Polarization And Government Accountability.pptx
Political Polarization And Government Accountability.pptx
EverlyseLumantas
PEN TO PODIUM powerpoint presentation.pptx
PEN TO PODIUM powerpoint presentation.pptx
Vanessa accad
Josaya - Abstract for the research of the youth development.pdf
Josaya - Abstract for the research of the youth development.pdf
Josaya Injesi
Joy In The Journey 06 22 2025.pptx
Joy In The Journey 06 22 2025.pptx
FamilyWorshipCenterD
Bob Stewart Acts 18 06 18 2025.pptx
Bob Stewart Acts 18 06 18 2025.pptx
FamilyWorshipCenterD
Ad

Date and Time FUNCTIONS

  • 1. DATE AND TIME FUNCTIONS
  • 2. The datetime datatypes are DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. Values of datetime datatypes are sometimes called datetimes.
  • 3. The interval datatypes are INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND. Values of interval datatypes are sometimes called intervals.
  • 4. YEAR MONTH DAY HOUR MINUTE SECOND
  • 5. DATE - format YYYY-MM-DD DATETIME - format: YYYY-MM-DD HH:MI:SS TIMESTAMP - format: YYYY-MM-DD HH:MI:SS YEAR - format YYYY or YY
  • 6. SELECT * FROM Orders WHERE OrderDate='2019-11-11'