Reader small image

You're reading from  Developing Robust Date and Time Oriented Applications in Oracle Cloud

Product typeBook
Published inMay 2023
PublisherPackt
ISBN-139781804611869
Edition1st Edition
Concepts
Right arrow
Author (1)
Michal Kvet
Michal Kvet
author image
Michal Kvet

Michal Kvet is a researcher, educator, and database expert at the University of Žilina in Slovakia. His primary focus areas are databases, analytics, performance, and cloud computing. He works closely with Oracle and Oracle Academy. He is the co-author of multiple textbooks (a SQL and PL/SQL cookbook, a book on APEX application development, a book on temporal databases, and a MySQL cookbook), coordinates multiple Erasmus+ projects and co-organizes several research conferences and database workshops. Besides this, he supervises engineering projects and bachelor's, master's, and doctoral theses. Over the years, his research has been associated with date and time management and temporal databases. He has Oracle's SQL, PL/SQL, Cloud, Analytics, and Administration certifications. His core knowledge of temporality is provided to you in this book.
Read more about Michal Kvet

Right arrow

Date value definition

Based on the standards approved by the American National Standards Institute (ANSI), values for the date are typically defined by the year, month, and day elements, ranging from 0001-01-01 through 9999-12-31, delimited by a specific symbol, such as a dot, comma, semicolon, or slash. Thus, we know that the value 2021-05-01 represents 1st May, not 5th January. The format for the Date value representation is YYYY-MM-DD, expressing the year (YYYY), month (MM), and day (DD) elements. To ensure correctness across the centuries, this standard requires a 4-digit year format to be applied precisely.

The available year definition ranges from 0000 to 9999, with 0000 being equal to 1 BCE (Before Common Era) and all subsequent values referring to CE (Common Era). ISO 8601 permits value management lower than 0000 if accepted by the sender and recipient, in which case, an expanded year definition with the + or sign is present. Thus, +0000 represents 1 BCE while ...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Developing Robust Date and Time Oriented Applications in Oracle Cloud
Published in: May 2023Publisher: PacktISBN-13: 9781804611869

Author (1)

author image
Michal Kvet

Michal Kvet is a researcher, educator, and database expert at the University of Žilina in Slovakia. His primary focus areas are databases, analytics, performance, and cloud computing. He works closely with Oracle and Oracle Academy. He is the co-author of multiple textbooks (a SQL and PL/SQL cookbook, a book on APEX application development, a book on temporal databases, and a MySQL cookbook), coordinates multiple Erasmus+ projects and co-organizes several research conferences and database workshops. Besides this, he supervises engineering projects and bachelor's, master's, and doctoral theses. Over the years, his research has been associated with date and time management and temporal databases. He has Oracle's SQL, PL/SQL, Cloud, Analytics, and Administration certifications. His core knowledge of temporality is provided to you in this book.
Read more about Michal Kvet