在SSIS中更改日期格式 [英] Changing date format in SSIS

问题描述

我正在尝试使用SSIS将数据从chinook db(oracle)移动到chinook DW(mysql).当前在我的oracle数据库中，我具有日期格式(07-AUG-11)并想要，因为我需要输入MYSQL(2011-08-07)，但我无法做到这一点.

I am trying to move data from chinook db(oracle) to chinook DW(mysql) using SSIS. Currently in my oracle db I have a date format(07-AUG-11) and want since I need to put in MYSQL(2011-08-07) but I am not able to do it.

我尝试在oracle中使用它进行转换

I tried using this in oracle for conversion

 select to_char(to_date(InvoiceDate,'DD-MON-YY'), 'YYYY-MM-DD') from CHINOOK.invoice;

并尝试在SSIS中使用表达式(从to_char开始)，但不起作用.(我也尝试过其他表达式，但是SSIS抛出错误，表明该函数不存在)

and tried using the expression(from to_char onwards) in SSIS but did not work. (there are also other expressions I tried but SSIS throws error saying the function does not exist)

我只需要知道SSIS中的表达是什么，如果有人可以帮忙

I just need to know whats the expression in SSIS.If anyone could help

推荐答案

我将使用(在Oracle中)将其作为日期带入SSIS:

I would bring it into SSIS as a date, using (in Oracle):

TO_DATE(InvoiceDate,'DD-MON-YY')

然后，如果您需要将其转换为'yyyy-MM-dd'格式的字符串，则可以使用类似的东西(在SSIS中):

Then if you need to convert it into a string with the 'yyyy-MM-dd' format, you can use something like (in SSIS):

(DT_WSTR, 4) YEAR(DateField) + "-" + RIGHT("0" + (DT_WSTR, 2) MONTH(DateField), 2) + "-" + RIGHT("0" + (DT_WSTR, 2) DAY(DateField), 2)

尽管，如果您的目的地是一个日期字段，那么它应该直接进入而无需任何处理/转换，因为它已经是一个日期了.

Although, if your destination is a date field, then it should go straight in without any processing/transformation as it is a date already.

这篇关于在SSIS中更改日期格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！