How to add 1 nano second to a timestamp

Asked Jul 27 '15 at 12:35

Active Jul 27 '15 at 12:37

Viewed 176 times

How to add 1 nano second to a timestamp.

I am doing this -

select CURRENT_TIMESTAMP + '0000-00-00 00:00:01' FROM SYSIBM.SYSDUMMY1

but it does not help me.

Can anyone please help me in this ?

edited Jul 27 '15 at 12:37

Tharif

asked Jul 27 '15 at 12:35

Govind

1

`'0000-00-00 00:00:01'` is not a nanosecond but a second – Cliff Burton Jul 27 '15 at 12:57

0 Answers0