oracle中如何插入时间,如何在Oracle中插入时间戳?

7

Kind of depends on where the value you want to insert is coming from. If you want to insert the current time you can use CURRENT_TIMESTAMP as shown in other answers (or SYSTIMESTAMP).

这取决于你想要插入的值来自哪里。如果想插入当前时间，可以使用CURRENT_TIMESTAMP，如其他答案(或SYSTIMESTAMP)所示。

If you have a time as a string and want to convert it to a timestamp, use an expression like

如果您有一个时间作为字符串，并希望将其转换为时间戳，请使用类似的表达式

to_timestamp(:timestamp_as_string,'MM/DD/YYYY HH24:MI:SS.FF3')

The time format components are, I hope, self-explanatory, except that FF3 means 3 digits of sub-second precision. You can go as high as 6 digits of precision.

我希望，时间格式组件是不言自明的，但FF3表示的是次秒精度的3位数。你可以达到6位数的精度。

If you are inserting from an application, the best answer may depend on how the date/time value is stored in your language. For instance you can map certain Java objects directly to a TIMESTAMP column, but you need to understand the JDBC type mappings.

如果是从应用程序中插入，最好的答案可能取决于日期/时间值在语言中的存储方式。例如，可以将某些Java对象直接映射到时间戳列，但是需要理解JDBC类型映射。