Oracle DML

Oracle TIMESTAMPs

The difference between a TIMESTAMP and a DATE is that a TIMESTAMP includes fractions of a second.

Converting a TIMESTAMP to a DATE

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)))

Next: RMAN 

Home > Computers > Databases > Oracle > DML > TIMESTAMPs

Viewing mobile website page. Switch to WML or Full HTML