作为时间间隔的 Teradata 宏参数

发布于 2024-10-16 10:20:46 字数 569 浏览 5 评论 0原文

这与 Informix 使用参数定义 INTERVAL 几乎是相同的问题但位于 Teradata 中。

我正在创建一个宏，它接受 hh:mm:ss 形式的字符串用作间隔。

该宏想要使用过去 hh:mm:ss 的时间戳执行某些操作。

这是基本的 SQL，

CREATE MACRO TEST_MACRO (
    HHMMSS CHAR(8)
)
AS
(
SELECT 
    CAST(CURRENT_TIME AS TIMESTAMP(0)),
    CAST(CURRENT_TIME - INTERVAL :HHMMSS HOUR TO SECOND AS TIMESTAMP(0))
)

我收到错误 Failed 3707：语法错误，需要在“INTERVAL”关键字和“:”之间出现字符串或 Unicode 字符文字。

有办法解决这个问题吗？

原文

This is almost the same problem as Informix defining an INTERVAL with a parameter but is in Teradata.

I'm creating a macro that accepts a string in the form hh:mm:ss to be used as an interval.

The macro wants to do something with a timestamp in the past hh:mm:ss.

Here's the basic sql

CREATE MACRO TEST_MACRO (
    HHMMSS CHAR(8)
)
AS
(
SELECT 
    CAST(CURRENT_TIME AS TIMESTAMP(0)),
    CAST(CURRENT_TIME - INTERVAL :HHMMSS HOUR TO SECOND AS TIMESTAMP(0))
)

I get the error Failed 3707: Syntax error, expected something like a string or a Unicode character literal between the 'INTERVAL' keyword and ':'.

Is there a way around this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

淡水深流 2024-10-23 10:20:46

知道了。

CREATE MACRO TEST_MACRO (
    HHMMSS CHAR(8)
)
AS
(
SELECT 
    CAST(CURRENT_TIME AS TIMESTAMP(0)),
    CAST(CURRENT_TIME - CAST(:HHMMSS AS INTERVAL HOUR TO SECOND) AS TIMESTAMP(0));
)

Got it.

CREATE MACRO TEST_MACRO (
    HHMMSS CHAR(8)
)
AS
(
SELECT 
    CAST(CURRENT_TIME AS TIMESTAMP(0)),
    CAST(CURRENT_TIME - CAST(:HHMMSS AS INTERVAL HOUR TO SECOND) AS TIMESTAMP(0));
)

回复收藏 0 原文

~没有更多了~