SQL日期参数

发布于 2025-02-08 15:22:27 字数 478 浏览 0 评论 0原文

我正在尝试将bigint列转换为日期，然后我需要将此日期用作SQL中的2个参数。我需要使用20200101的起点，并且结束日期如今需要像getDate（）一样。

这是一个错误，我找不到如何做。

set @date1 TRY_CAST(CAST(CAST([DischargeDateKey] AS BIGINT) AS VARCHAR(8)) AS DATETIME)
set @date2 TRY_CAST(CAST(CAST([DischargeDateKey] AS BIGINT) AS VARCHAR(8)) AS DATETIME)

DECLARE @date1 AS datetime = 20200101
DECLARE @date2 AS datetime  = 20220531

msg 102，级别15，状态1，第3行不正确的语法“ try_cast”。

请有人帮忙吗？

原文

I am trying to convert bigint column to a date, and I then need to use this date as 2 parameters in SQL. I need to use a startdate off 20200101 and the end date needs to be today, like a getdate().

This is coming up with an error and I can't find out how to do it.

set @date1 TRY_CAST(CAST(CAST([DischargeDateKey] AS BIGINT) AS VARCHAR(8)) AS DATETIME)
set @date2 TRY_CAST(CAST(CAST([DischargeDateKey] AS BIGINT) AS VARCHAR(8)) AS DATETIME)

DECLARE @date1 AS datetime = 20200101
DECLARE @date2 AS datetime  = 20220531