<div>
Try this :::<br />
<br />
create table abcd ( col1 datetime)<br />
<br />
insert into abcd <br />
select GETDATE()<br />
<br />
select * from abcd<br />
<br />
Result Set:<br />
2011-05-11 17:59:51.927
</div>


Try this :::

create table abcd ( col1 datetime)

insert into abcd
select GETDATE()

select * from abcd

Result Set:
2011-05-11 17:59:51.927

<div>
@ qasim_md<br />
<br />
The question is in Oracle Zone. Your solution will work only on SQLServer.
</div>


@ qasim_md

The question is in Oracle Zone. Your solution will work only on SQLServer.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
&nbsp;I have the following table. It onlys stores mm/dd/yyy &nbsp;hh:mm:ss:. &nbsp;I would like to see milli or even better micros. How do i do that?<br />
<br />
NAME &nbsp; &nbsp;TYPE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULLABLE &nbsp; &nbsp; DEFAULT<br />
column1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar2(2500) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;y &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
column2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar2(250) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;y &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
column3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar2(205) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;y &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
column4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar2(250) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;y &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
column5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;timestamp(6) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sysdate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />

</div>
</div>


Hello Experts,
 I have the following table. It onlys stores mm/dd/yyy  hh:mm:ss:.  I would like to see milli or even better micros. How do i do that?

NAME    TYPE            NULLABLE     DEFAULT
column1	varchar2(2500)	y		
column2	varchar2(250)	y		
column3	varchar2(205)	y		
column4	varchar2(250)	y		
column5	timestamp(6)	               sysdate	


Want to get sysdate down to millisecond or microsecond if possible

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.