SSIS 表达式:将日期转换为字符串 [英] SSIS expression: convert date to string

问题描述

我是 SSIS 的新手，我正在尝试将 GetDate() 转换为字符串DD-MM-YYYY".这是我迄今为止构建的表达式:

I'm new to SSIS and I'm trying to convert a GetDate() to string "DD-MM-YYYY". This is the expression I've built so far:

(DT_WSTR, 8)  DAY( GETDATE()) + "-" + (DT_WSTR, 8)  (MONTH(GETDATE()) - 1) + "-" + (DT_WSTR, 8) YEAR(GETDATE())

我遇到的问题是 Month() 将月份23-4-2013"​​转换为单个字符，当我想要双字符时，与日相同.不管是什么月份，我如何把它变成双字符?

The problem I've got is Month() converts the Month "23-4-2013" to a single character when I want it in Double character, same as day. How do i make it into a double character no matter what month it is?

推荐答案

对于 SSIS，您可以使用:

For SSIS you could go with:

RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2) + "-" +  (DT_STR, 4, 1252) DATEPART("yy" , GETDATE())

表达式生成器屏幕:

这篇关于SSIS 表达式:将日期转换为字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！