blocks|key|5333555|text|由于DATE的精度是秒(而不是秒的分数)，所以根本不需要TRUNC。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5333556|数据类型TIMESTAMP允许数秒的分数。如果您将其转换为DATE，小数秒将被删除-例如|5333557|select+cast(systimestamp+as+date)+
++from+dual;|code-block|syntax|javascript|5333558|entityMap^0|2|4|S|5|0|4|9|T|4|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

Since the precision of <code>DATE</code> is to the second (and no fractions of seconds), there is no need to <code>TRUNC</code> at all.

The data type <code>TIMESTAMP</code> allows for fractions of seconds. If you convert it to a <code>DATE</code> the fractional seconds will be removed - e.g.

<pre><code>select cast(systimestamp as date) 
 from dual;
</code></pre>

blocks|key|3078213|text|我很抱歉，但我的前辈似乎都错了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3078214|select+cast(systimestamp+as+date)+from+dual+|code-block|syntax|javascript|3078215|..does不会截断，而是舍入到下一秒。|3078216|我使用一个函数：|3078217|CREATE+OR+REPLACE+FUNCTION+TRUNC_TS(TS+IN+TIMESTAMP)+RETURN+DATE+AS
BEGIN

++++RETURN+TS;

END;|3078218|例如：|3078219|SELECT+systimestamp
++++,trunc_ts(systimestamp)+date_trunc
++++,CAST(systimestamp+AS+DATE)+date_cast+
FROM+dual;|3078220|返回：|3078221|++++SYSTIMESTAMP+++++++++++++++++++++++DATE_TRUNC+++++++++++++DATE_CAST
++++21.01.10+15:03:34,567350+%2B01:00++++21.01.2010+15:03:34++++21.01.2010+15:03:35|3078222|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

I am sorry, but all my predecessors seem to be wrong.

<pre><code>select cast(systimestamp as date) from dual 
</code></pre>

..does not truncate, but rounds to the next second instead.

I use a function:

<pre><code>CREATE OR REPLACE FUNCTION TRUNC_TS(TS IN TIMESTAMP) RETURN DATE AS
BEGIN

 RETURN TS;

END;
</code></pre>

For example:

<pre><code>SELECT systimestamp
 ,trunc_ts(systimestamp) date_trunc
 ,CAST(systimestamp AS DATE) date_cast 
FROM dual;
</code></pre>

Returns:

<pre><code>
 SYSTIMESTAMP DATE_TRUNC DATE_CAST
 21.01.10 15:03:34,567350 +01:00 21.01.2010 15:03:34 21.01.2010 15:03:35
</code></pre>

blocks|key|5333673|text|关于截断Oracle日期的一般主题，下面是可在date+trunc()和round()函数中使用的格式模型的文档链接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5333674|http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions242.htm#sthref2718|offset|length|5333675|没有列出“秒”，因为DATE数据类型的粒度是秒。|5333676|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2I|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

On the general topic of truncating Oracle dates, here's the documentation link for the format models that can be used in date trunc() AND round() functions

<a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions242.htm#sthref2718" rel="nofollow noreferrer">http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions242.htm#sthref2718</a>

"Seconds" is not listed because the granularity of the DATE datatype is seconds.

blocks|key|5333755|text|我使用的函数如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5333756|FUNCTION+trunc_sec(p_ts+IN+timestamp)
IS
++++p_res+timestamp;
BEGIN
++++RETURN+TO_TIMESTAMP(TO_CHAR(p_ts,+'YYYYMMDDHH24MI'),+'YYYYMMDDHH24MI');
END+trunc_sec;|code-block|syntax|javascript|5333757|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I used function like this:

<pre><code>FUNCTION trunc_sec(p_ts IN timestamp)
IS
 p_res timestamp;
BEGIN
 RETURN TO_TIMESTAMP(TO_CHAR(p_ts, 'YYYYMMDDHH24MI'), 'YYYYMMDDHH24MI');
END trunc_sec;
</code></pre>

blocks|key|3078264|text|trunc工作仅限于最小，转换为最新to_char(START_TIME,'YYYYMMDDHH24MISS')|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3078265|或者干脆用select+to_char(current_timestamp,+'YYYYMMDDHH24MISS')+from+dual;|3078266|https://www.techonthenet.com/oracle/functions/trunc_date.php|3078267|entityMap|0|LINK|mutability|MUTABLE|url^0|I|12|0|5|1S|0|0|1O|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|J|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|I]]]]

trunc work to min only, cast to date <code>to_char(START_TIME,'YYYYMMDDHH24MISS')</code> 

or simply <code>select to_char(current_timestamp, 'YYYYMMDDHH24MISS') from dual;</code>

<a href="https://www.techonthenet.com/oracle/functions/trunc_date.php" rel="nofollow noreferrer">https://www.techonthenet.com/oracle/functions/trunc_date.php</a>

blocks|key|794951|text|要将timestamp截断为秒，可以将其转换为日期：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|794952|CAST(timestamp+AS+DATE)|code-block|syntax|javascript|794953|然后执行本文中的TRUNC：|794954|TRUNC(CAST(timestamp+AS+DATE),+'YEAR')|794955|entityMap^0|2|9|0|0|8|5|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

To truncate a <code>timestamp</code> to seconds you can cast it to a date:



<pre class="lang-sql prettyprint-override"><code>CAST(timestamp AS DATE)
</code></pre>

To then perform the <code>TRUNC</code>'s in the article:

<pre class="lang-sql prettyprint-override"><code>TRUNC(CAST(timestamp AS DATE), 'YEAR')
</code></pre>

blocks|key|794983|text|大概是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|794984|select+to_char(current_timestamp,+'SS')+from+dual;|code-block|syntax|javascript|794985|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Something on the order of:

<pre><code>select to_char(current_timestamp, 'SS') from dual;
</code></pre>

<a href="http://www.techonthenet.com/oracle/functions/trunc_date.php]" rel="noreferrer">This page</a> mentions how to trunc a timestamp to minutes/hours/etc. in Oracle.

How would you trunc a timestamp to seconds in the same manner?

How to trunc a date to seconds in Oracle

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

提到了如何在Oracle中将时间戳转换为分钟/小时/等。如何以同样的方式将时间戳转换为秒？

问如何在Oracle中将日期转换为秒
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle中将日期转换为秒EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle中将日期转换为秒
EN