<div>
TIMESTAMP [(&lt;precision&gt;)]<br />
<br />
The TIMESTAMP datatype stores date and time information with fractional<br />
seconds precision. The only difference between the DATE and TIMESTAMP<br />
datatypes is the ability to store fractional seconds up to a precision of nine digits.<br />
The default precision is 6 and can range from 0 to 9. 
</div>


TIMESTAMP [(<precision>)]

The TIMESTAMP datatype stores date and time information with fractional
seconds precision. The only difference between the DATE and TIMESTAMP
datatypes is the ability to store fractional seconds up to a precision of nine digits.
The default precision is 6 and can range from 0 to 9.

<div>
&gt;insert into my_table (timestamp_column) values (timestamp'1997-01-31 09:26:50.124');<br />
<br />
Is this part ok: &nbsp; (timestamp'1997-01-31 09:26:50.124'); ?<br />
<br />
Should it just be: &nbsp; ('1997-01-31 09:26:50.124'); <br />
<br />
<br />
_Esam
</div>


>insert into my_table (timestamp_column) values (timestamp'1997-01-31 09:26:50.124');

Is this part ok:   (timestamp'1997-01-31 09:26:50.124'); ?

Should it just be:   ('1997-01-31 09:26:50.124');


_Esam

<div>
Need an example of how to insert a darn timestamp&gt;&gt;&gt;:)<br />
<br />
<br />
Thax.<br />
_esam.
</div>


Need an example of how to insert a darn timestamp>>>:)


Thax.
_esam.

<div>
Sorry, I got it working now...:)<br />
<br />
Thanks<br />
<br />
_Esam..
</div>


Sorry, I got it working now...:)

Thanks

_Esam..

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have an Oracle (9.2.0) table column that is of type Timestamp...<br />
<br />
The DBA declared it as: <br />
<br />
ColumnName &nbsp; &nbsp; &nbsp;Type<br />
CREATETMS &nbsp; &nbsp; &nbsp; Timestamp(6)<br />
<br />
My question is: what does this mean? &nbsp; &nbsp; Timestamp(6) &nbsp;?<br />
Give me an example insert value to insert a value to this column??? (should work)<br />
I am having problem updating this Timestamp with new values from my java program....<br />
<br />
<br />
Thanks.<br />
_Esam.
</div>
</div>


Hi,
I have an Oracle (9.2.0) table column that is of type Timestamp...

The DBA declared it as: 

ColumnName      Type
CREATETMS       Timestamp(6)

My question is: what does this mean?     Timestamp(6)  ?
Give me an example insert value to insert a value to this column??? (should work)
I am having problem updating this Timestamp with new values from my java program....


Thanks.
_Esam.

Oracle Timestamp size ?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.