<<Previous Next>>
Oracle - Differences between DATE and TIMESTAMP
in Oracle - Feb 18, 2010 at 11:00 PM by Rajmeet
Ghai
Differences between DATE and TIMESTAMP in Oracle
DATE in Oracle returns month, day, year, century, hours, minutes,
and seconds. For more granular details, TIMESTAMP should be used.
TIMESTAMP also returns fraction of seconds that helps to identify
which event occurred first.
Example:
DATE: 16-DEC-08
TIMESTAMP: 16-DEC-08
12.12.23.000000000 PM
Oracle - Differences between
DATE and TIMESTAMP in Oracle - Feb 07, 2010 at 14:20 PM by
Shuchi Gauri
Differences between DATE and TIMESTAMP in Oracle
Date
is used to store date and time values including month, day, year,
century, hours, minutes and seconds. It fails to provide granularity
and order of execution when finding difference between 2 instances
(events) having a difference of less than a second between them.
TimeStamp datatype stores everything that Date
stores and additionally stores fractional seconds.
Date: 16:05:14
Timestamp: 16:05:14:000
Oracle - Differences between DATE and TIMESTAMP in Oracle - April 10, 2009
at 11:00 AM
Differences between DATE and TIMESTAMP in Oracle
TIMESTAMP and DATE vary in formats as follows:
- DATE stores values as century, year, month, date, hour,
minute, and second.
- TIMESTAMP stores values as year, month, day, hour, minute,
second, and fractional seconds.
Also read
UNION: The UNION operator is used to combine the result-set of
two or more SELECT statements Tables of both the select statement
must have the same number of columns with similar data types. It
eliminates duplicates..........
What is the content view and stacked view?, Explain the different
types of canvas views, Explain the significance of OR REPLACE, FORCE
and NOFORCE while creating view.............
CHAR and NCHAR are character data types which and have a fixed
length.......
CHAR values have a fixed length. They are padded with space
characters to match the specified length............
|
