从 oracle tmstmp 字段中删除毫秒
我在 Oracle 中有一个 TIMESTAMP(6) 字段,我需要从时间中删除毫秒部分.
I have a TIMESTAMP(6) field in Oracle and I need to remove the millisecond component from the time.
例如我有
10/20/2014 10:34:06.356000 AM
我想删除毫秒,以便我有
and I would like to remove the milliseconds so that I have
10/20/2014 10:34:06 AM
您知道这样做的最佳方法吗?
Do you know the best way to do this?
谢谢!
推荐答案
这个怎么样?
select cast(col as timestamp(0))
避免四舍五入的最简单方法是使用 trunc()
或减去半秒:
The easiest way to avoid rounding is to use trunc()
or to subtract half a second:
select cast(col - 0.5/(24*60*60) as timestamp(0))
相关文章