Murach's Oracle SQL and PL/SQL
How to work with timestamps and intervals

This chapter shows how to use the new TIMESTAMP and INTERVAL data types that were introduced with Oracle Database 9i. These data types extend the functionality of the DATE type, making it easier to work with time zones, fractional seconds, and time intervals.
Chapter 17 How to work with timestamps and intervals
An introduction to time zones 532
Database time zone vs. session time zone 532
How to change the default date format 534
How to change the default time zone 534
Session settings vs. database settings 534
How to use functions to work with time zones 536
How to work with timestamps 538
An introduction to the TIMESTAMP types 538
How to work with the TIMESTAMP type 540
How to work with the TIMESTAMP WITH LOCAL TIME ZONE type 542
How to work with the TIMESTAMP WITH TIME ZONE type 544
Common format elements for timestamps 546
How to use functions to work with timestamps 548
How to work with intervals 552
An introduction to the INTERVAL types 552
How to work with the INTERVAL YEAR TO MONTH type 554
How to work with the INTERVAL DAY TO SECOND type 556
How to use functions to work with intervals 558


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.