从 oracle tmstmp 字段中删除毫秒

removing milliseconds from a oracle tmstmp field(从 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))

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