about to store millseconds ..

[Sekhar]

Hi Friends,

I want to Store in mydatabase time with millseconds. Is it Possible to Store this in Oracle? Upto My knowledge i know that the Date Datatype will store Hours,Minutes and seconds.

Sekhar

[ramekar]

U R right? I think you have to use JAVA for getting the millsec, if you want, and store in separate field.

[julian]

You can use DBMS_UTILITY.GET_TIME but have in mind that it is not syncronized with SYSDATE. The time you get (a number) is the number of 100th's of a second from some arbitrary epoch.

In 9i, there are new time formats, one of them is TIMESTAMP it shows the miliseconds even with precision of 9, default is 6.

[pando]

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> alter session set events '10406 trace name context forever';

Session altered.

SQL> create table a (kk timestamp);  

Table created.

SQL> insert into a values(sysdate);

1 row created.

SQL> select * from a;

KK
---------------------------------------------------------------------------
17-JAN-02 11.38.54 AM

cool huh

[julian]

cool huh

Yep :-)

Even this is possible;

insert into a values(systimestamp);

But look at select * from a;




[Edited by julian on 01-17-2002 at 07:02 AM]

[vijayr]

Hi,


Can anyone please elaborate on set events '10406 trace name context forever' or tell me where can I get more info on this.


Thanks and Regards,
Vijay R.

[pando]

10406 is used to enable timestamp dtaatype in Oracle 8i, of course it's not supported officially

[jmodic]

True, this event enables you to store timestamp dataype values and use timestamp related functions inside 8i, but don't be fooled by this semi-feature! For example, it alows you to use SYSTIMESTAMP as Julian has pointed out, but make some tests with SYSTIMESTAMP inserts and see what fractional seconds are realy stored! Definitely not something that has anything to do with miliseconds or system clock! :(

[pando]

000000000

:(

[ramekar]

cool