Post Your Answer

Temporal data types in oracle

5 years ago in Data collection By Yashti Iyer

PhD Data

Can someone explain temporal data types in oracle? It would be of great help guys

All Answers (3 Answers In All) Post Your Answer

By Karan D Answered 5 years ago

Date Data Type : This type consists dates of different formats TimeStamp Data Type: This type of data type consists timestamp of different format Interval Data Type: Here we have interval between time and date

Reply To Karan D

By Kamlesh Meena Answered 5 years ago

There are 3 types of temporal data types in oracle. Date data type, timestamp data type and interval data type. The Date data type holds not just date but also time information. Oracle stores dates internally regardless of the date format that is displayed. Timestamp data types provides support for fractional seconds along with date and time data.It also provides support for time zones.

Reply To Kamlesh Meena

View Related Questions

Import data in R

1148
Views
23
Votes
3
Answer

asked at 31 Dec, 2019 01:23 in Data collection By Lalit Mudra

Best NLP technique for extracting information from the text

1299
Views
32
Votes
3
Answer

asked at 18 May, 2019 12:23 in Data collection By Riya N

Brief details about Ethnography technique

995
Views
23
Votes
3
Answer

asked at 04 May, 2019 10:11 in Data collection By Anubhav Kumar

Types of data collection method in qualitative research method

718
Views
53
Votes
5
Answer

asked at 11 Apr, 2019 09:18 in Data collection By Dani khan

Can data be collected in grid format using ground penetrating radar?

1534
Views
65
Votes
4
Answer

asked at 11 Apr, 2019 06:01 in Data collection By Jeff

Can experimental method be used to collect data in quantitative research?

1301
Views
48
Votes
4
Answer

asked at 10 Apr, 2019 09:18 in Data collection By Shiran Khan

Formulas used to calculate sample size?

658
Views
76
Votes
3
Answer

asked at 25 Aug, 2018 07:43 in Data collection By Amrita Goyal

From where I can get my data?

625
Views
41
Votes
1
Answer

asked at 30 Jul, 2018 09:00 in Data collection By Yashti Iyer

249
Views
23
Votes
3
Answer

asked at 18 Jul, 2018 10:09 in Data collection By Keshav Verma

MANCOVA statistics

389
Views
71
Votes
3
Answer

asked at 12 Jul, 2018 16:57 in Data collection By Pradeep Sharma

Help in data collection!!

551
Views
27
Votes
1
Answer

asked at 12 Jul, 2018 09:54 in Data collection By Keshav Verma

Data collection

419
Views
79
Votes
4
Answer

asked at 09 Jul, 2018 15:53 in Data collection By Sur M

Research papers related to my area of research.

339
Views
73
Votes
3
Answer

asked at 07 Jul, 2018 14:13 in Data collection By Yashti Iyer

Primary and secondary data

310
Views
82
Votes
3
Answer

asked at 07 Jul, 2018 12:31 in Data collection By Sonali Jain

Advance your Research by
Joining the Community

Sign up for free

Connect on familiar ideas on various subjects

PhD Admissions
Action Research
APA Style
Annexure I Journals
Academic Writing
Abstract
Content Analysis
PhD Thesis
Qualitative Research
Research Proposal
Research Question
Review Paper
SPSS
Structural Analysis
SWOT Analysis
Synopsis
Technical Writing
Topic
Topic Selection
Turnitin
University Guidelines
Plasma
API
Python
Training
Big Data
Cloud Computing
Structural Equation Modelling
Statistics
Blockchain