The difference between a TIMESTAMP and a DATE is that a TIMESTAMP includes fractions of a second.
An Oracle TIMESTAMP value can easily be converted to a DATE. To convert to a DATE with no time component, use:
to_date(trunc(timestamp_value))
To convert to a DATE with a date and time, use:
to_date(substr(timestamp_value,1,length(sysdate)))
Last updated Tuesday January 2, 2007
Printer-friendly PDF* format:
You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.
