如何使用SSIS表达式将格式为dd.mm.yyyy的字符串转换为日期? [英] How to convert string in format dd.mm.yyyy to date using SSIS expression?

问题描述

我在CSV中有一个日期26.12.2019(dd.mm.yyyy)，我正尝试使用SSIS中的派生列将其转换为2019-12-26.我已经使用了此表达式，但是它似乎不起作用.

I have a date 26.12.2019 (dd.mm.yyyy) in CSV which I'm trying to convert to 2019-12-26 using Derived Column in SSIS. I have used this expression but it does not seem to work.

(TRIM([Period Start Date]) == "") ? NULL(DT_DATE) : (DT_DATE)(SUBSTRING([Period Start Date],7,4) + "-" + SUBSTRING([Period Start Date],4,2) + "-" + SUBSTRING([Period Start Date],1,2)) 

如何重写此表达式以产生具有数据类型值的正确输出?

How do I rewrite this expression to produce the correct output with a value of data type?

推荐答案

使用DT_DATE数据类型时，值不会以特定格式保存，而是根据您的操作系统区域设置显示.如果需要使用特定格式，可以将其保留为字符串，如下所示:

When using DT_DATE data type, value is not saved in a specific format, it is shown based on your operating system regional settings. If you need to use a specific format, you can keep it as string as following:

(TRIM([Period Start Date]) == "") ? NULL(DT_WSTR,50) : (DT_WSTR,50)(SUBSTRING([Period Start Date],7,4) + "-" + SUBSTRING([Period Start Date],4,2) + "-" + SUBSTRING([Period Start Date],1,2)) 

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