O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. The Circa Data Type

This section describes the Circa data type syntax. The syntax does not cover every keyword or period in time, but it does cover the vast majority of them. The syntax supports the addition of new time periods.

The following are the examples of Circa values that the syntax can describe:

  • 1850 to 20-Jan-1910
  • About 18,000 years ago
  • 1850s
  • 1910 to 1980
  • c. 1760 to c. 1810
  • 1800 to 1830
  • Second to third millennium BC
  • 8th century BC
  • Late 1930s
  • 304 to 250 BC
  • c. 1927 to 30
  • Late 1960s to early 1970s
  • c.1760-c.1810 [1750-1830]
  • c.1760- c.1810 [1750-1830]
  • c. 1760- c. 1810

Railroad diagram

Circa: It covers the initial circa date value.

Railroad diagram

Date: It defines ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required