You are currently using a web browser that does not support HTML 5. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.
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 HTML 5 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML 5 XML*HTML 5 non-XML*XHTML 1 Style Sheet*XHTML 1*XML* HTML 4* 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.