Change Date format in DTS
-
Guys hi,
i need your help on this...
i am copying data from a ascii file to a table.
the ascii file has the dates in the following format
22-3-1998. This is not recognized as a date since it has dashes.
If i try to convert this ascii column into a date format using cdate, then i get the date but in the american "way" 3/22/1998. How can i tranform it to a dateformat like 16/3/1998?
Thanks in advance,
Dionisis
-
Have you looked at SELECT CONVERT(VARCHAR(50), GETDATE(), 103)?
Good Hunting!AJ Ahrens
webmaster@kritter.net -
using active x put the date 8-8-1999 format in a variable, do a replace of the - to / . next do a isdate on the field. if it passes save the in the dest field.
-
How about using the built-in Datetime transformation task ??
--------------------
Colt 45 - the original point and click interface
-
Agree with Phill, I have used the built in datetime transform when dealing with crap data coming in from an Oracle SAP system. You can specify a number of formats of datetime to covert to.
Select transform data task properties and then under transformations choose new and select date time string.
Derek
-
That did it for me as well Guys! 🙂 Cheers! 🙂
The script (activeX vbscript in a DTS package), in case someone is interested is as follows..
Function Main()
if Left( DTSSource("Source Column Name"), 2) = " " then
DTSDestination("Destination Field") = null
Else DTSDestination("ADM_DATE") = FormatDateTime( DTSSource("Col008") , 2)
end if
Main = DTSTransformStat_OK
End Function
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply