Input table, Single_Date with date field as Date1 varchar(10) having the In "mm-dd-yyyy" or "yyyy-mm-dd" formats as well ?
My Question No 1: Does the incoming date have to be in the same format as My Requirement: Want my output date in the format "dd-mm-yyyy". I have tried all the options and gone through all the posts and only then Subject: Datastage 8.1 > String To Date Conversion Like if the input string is mmddyyyy and want to convert to yyyy-mm-dd,Īnd assume the input field name is InDate, you can specify as following in Treat the input as String and convert it by yourself. If you want to convert the string to other format, I would suggest to No way to identify which format if the date format varies in the series ofĪnd the default format is defined in the Project Default as Daren Input string SHOULD have the same format for that particular job. Looking forward for suggestions/solutions. The above expression Failed during Run with Warnings and Fatal Errors. Is it possible ?īecause, when I tried StringToDate(DSLink3.Date1,""%dd/%mm/%yyyy"") My Question No 2: Now what if I want to convert the same incoming date to dd-mm-yyyy or yyyy-mm-dd. In Datastage Transformer, I did the following: Output table, Single_Date_Output with date field as Date1 date. Input table, Single_Date with date field as Date1 varchar(10) having the value """". My Question No 1: Does the incoming date have to be in the same format as the output for e.g should it be ""24-06-1983"" or ""27-05-2009"" or it can be in ""mm-dd-yyyy"" or ""yyyy-mm-dd"" formats as well ? My Requirement: Want my output date in the format ""dd-mm-yyyy"". I have tried all the options and gone through all the posts and only then putting forward my issue.
0 kommentar(er)
