Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Using TIMESTAMP

Simple TIMESTAMP allows you to specify fractions of a second. DATE precision is limited to seconds. declare     variable1_ts TIMESTAMP[(precision)]; begin     NULL; end; Oracle stores 6 digits of precision, but you can specify precision within the range from 0 to 9. TIMESTAMP(0) is equivalent to DATE.