从oracle tmstmp字段中删除毫秒 [英] removing milliseconds from a oracle tmstmp field

问题描述

我在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))

这篇关于从oracle tmstmp字段中删除毫秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！