开发者

How to insert date and time with fractional seconds in Oracle?

开发者 https://www.devze.com 2023-01-09 08:14 出处:网络
I\'m using oracle 11g. I\'m inserting date and time using function SYSDATE into column with type TIMESTAMP. But fractional seconds always are 0.

I'm using oracle 11g. I'm inserting date and time using function SYSDATE into column with type TIMESTAMP. But fractional seconds always are 0. How can I insert date and time of da开发者_如何学Pythontabase server with fractional seconds? Is there any functions?


Use SYSTIMESTAMP instead of SYSDATE.

0

精彩评论

暂无评论...
验证码 换一张
取 消