Date Conversion!

Last Post 25 Apr 2002 06:20 PM by Lee. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
LACBA_SQL
New Member
New Member

--
25 Apr 2002 12:23 PM
I have a DTS that needs to convert a DB2 format into a readable format...
I'm importing a table with a field call date and the format is as fallow CYYMMDD Century, year, month, day... for example 1020425 is 1st century year 02 month 04 day 25,
How can I convert that into a date field to read like this " 04/25/2002". forget about century...
Thanks
Lee
New Member
New Member

--
25 Apr 2002 06:20 PM
I've used the newest tools extensively in building a data mart over the last year and have come to the opinion that....forget all of the activex, data driven query, all that stuff, because it's a row by row, cursor-based type programmatic operation, and for my money, I choose set-based operations. Especially for working with millions of records.

What I would do is create a staging table and simply import the data as is. Create a stored procedure that does a SELECT INTO into another table and complete your data scrubbing and formatting at this time from the staging table. It will run much faster than a row-based operation (this is of course if you don't have one of the great new ETL tools such as Informatica).

Row by row processing is nowhere at my place.

Hope this helps some


You are not authorized to post a reply.

Acceptable Use Policy