Adding milliseconds to a timestamp Options

[Omer Alvi]

Hi all

I want to add milliseconds to my timestamp object. For example I have to increment the timestamp value by 25 milliseconds in each iteration of a loop. Is there any way to do that?

Cheers

[burleson]

Hi,

>> I have to increment the timestamp value by 25 milliseconds in each iteration of a loop.

Sure, Mike Ault has an example here of incrementing a timestamp:

http://www.dba-oracle.com/t_timespamp_math_elapsed_times.htm

[Omer Alvi]

Hi Burleson,

Hi,

>> I have to increment the timestamp value by 25 milliseconds in each iteration of a loop.

Sure, Mike Ault has an example here of incrementing a timestamp:

http://www.dba-oracle.com/t_timespamp_math_elapsed_times.htm

Thanks for your reply.I really appreciate that. Your suggested article helped me in converting a timestamp into milliseconds, but I still could not get how to increment the time stamp value by milliseconds (e.g., 25 milliseconds).

Best regards,

[burleson]

Hi,

The article shows working code for getting the millisecond difference between two timezone columns, right?

http://www.dba-oracle.com/t_timespamp_math_elapsed_times.htm

"So now we can get the milliseconds between . . . "

[Omer Alvi]

Hi,

The article shows working code for getting the millisecond difference between two timezone columns, right?

http://www.dba-oracle.com/t_timespamp_math_elapsed_times.htm

"So now we can get the milliseconds between . . . "

Dear Burleson,

I am sorry I could not put my question properly. Lemme put it this way. After converting a timestamp into milliseconds and then adding some milliseconds in that value, Can we convert those milliseconds into a new timestamp ?

[Manfred]

Hi Omer

Take the followin as an example:

select to_char(systimestamp,'dd-mm-yyyy hh24:mi:ss.FF') as ts
, to_timestamp(to_char(sysdate,'dd-mm-yyyy hh24:mi:ss.')||to_char(to_number(to_char(systimestamp,'FF')) + 250)
,'dd-mm-yyyy hh24:mi:ss.FF') as ts_1
from dual;

Looks screwy and it is probably not usefull using all this conversions, but it works!

Regrads

Manfred

[Omer Alvi]

Hi Omer

Take the followin as an example:

select to_char(systimestamp,'dd-mm-yyyy hh24:mi:ss.FF') as ts
, to_timestamp(to_char(sysdate,'dd-mm-yyyy hh24:mi:ss.')||to_char(to_number(to_char(systimestamp,'FF')) + 250)
,'dd-mm-yyyy hh24:mi:ss.FF') as ts_1
from dual;

Looks screwy and it is probably not usefull using all this conversions, but it works!

Regrads

Manfred

Thanks Manfred. Yes it works and increases milliseconds. But it does not affect the seconds field. For example if we add 1000 millisecods then ideally the seconds field should be incremented. We know there is way to convert a timestamp into milliseconds. Is there any way to convert the milliseconds back to timestamp ? Or if ther is any way of adding milliseconds to the timestamp object which does reflect changes in seconds filed?

Thank you very much for your help.

Best regards

[HariS]

I used the numtodsinterval like:

select systimestamp, systimestamp+numtodsinterval(0.33,'SECOND') from dual;

Thanks Manfred. Yes it works and increases milliseconds. But it does not affect the seconds field. For example if we add 1000 millisecods then ideally the seconds field should be incremented. We know there is way to convert a timestamp into milliseconds. Is there any way to convert the milliseconds back to timestamp ? Or if ther is any way of adding milliseconds to the timestamp object which does reflect changes in seconds filed?

Thank you very much for your help.

Best regards