sql - 强制转换函数以仅显示日期时间中的月份和日期

Question

SELECT 
    DateAdded, 
    Cast(DateAdded AS Date) AS DateAddedV1, 
    Cast(DateAdded AS Time) AS DateTime, 
    SELECT CAST(DateAdded AS Date(mm:dd) AS OrderDate
FROM Products

我是 SQL 的初学者，我试图将 DateAdded 列作为 OrderDate 返回，只有月份和日期，但我似乎无法获得正确的语法.我感谢任何人的帮助。

Answer 1

使用DatePart函数从Datetime类型中提取day和month,

Select Datepart(Month,DateAdded) AS [Month], -- Month(Dateadded)
       Datepart(Day,DateAdded) as [Day], -- Day(Dateadded)
       ..
From   Products

更新:只有使用cast 函数才能提取Month 和Day。如果你想在同一列中保留月份和日期

    SELECT CONVERT(VARCHAR(2), Month(DateAdded)) + ':'
           + CONVERT(VARCHAR(2), Day(DateAdded)) 
           .....

要获得前导零，请使用 right 函数并从 DateAdded 中提取 Time 使用 Convert 函数和 108 值

SELECT right('0'+CONVERT(VARCHAR(2), Month(DateAdded)),2) + ':'
       + right('0'+CONVERT(VARCHAR(2), Day(DateAdded)) ,2) as [Mon:Day],
         convert(varchar(10),DateAdded,108) as [Time]
       .........