Ask, Learn and Accelerate in your PhD Research

Login Sign up

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)

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

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.

By Meghana R Answered 5 years ago

Visit http://etutorials.org/SQL/Mastering+Oracle+SQL/Chapter+6.+Handling+Temporal+Data/6.2+Temporal+Data+Types+in+Oracle/

View Related Questions

Import data in R

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

1180 Views
23 Votes
3 Answer

Best NLP technique for extracting information from the text

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

1324 Views
32 Votes
3 Answer

Brief details about Ethnography technique

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

1012 Views
23 Votes
3 Answer

Types of data collection method in qualitative research method

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

742 Views
53 Votes
5 Answer

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

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

1555 Views
65 Votes
4 Answer

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

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

1323 Views
48 Votes
4 Answer

Formulas used to calculate sample size?

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

676 Views
76 Votes
3 Answer

From where I can get my data?

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

646 Views
41 Votes
1 Answer

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

249 Views
23 Votes
3 Answer

MANCOVA statistics

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

409 Views
71 Votes
3 Answer

Help in data collection!!

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

573 Views
27 Votes
1 Answer

Data collection

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

439 Views
79 Votes
4 Answer

Research papers related to my area of research.

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

359 Views
73 Votes
3 Answer

Primary and secondary data

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

328 Views
82 Votes
3 Answer