Hi

I have a Platinum database which stores dates in integar form e.g the date
is formatted as below:

Column_name Type Length
Precision
------------------------------ ------------------------------
from_date int 4
10


Some of the dates in the Platinum database are as follows:

729115
729359
730059
730241
730302
730455

How can I bring them into SQL 2000 as valid dates.

Thanks for your assistance

Sam C
s_commar (AT) hotmail (DOT) com

What does the date mean?

Does it mean a given number of intervals past a certain time/date?

If they do then sure we can use a function to do this in an Active Script
transform (DATEADD())

If however PLatinum has such a facility it would be more efficient to do it
there.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Sam" <s_commar (AT) hotmail (DOT) com> wrote

Thanks for your reply
When I copy the integar dates into Excel and choose -format -Date -it
give me a date which is more or less ok. My issue is how do I bring the
integar into another SQL databases with the date format.

Thanks

Sam



*** Sent via Developersdex http://www.developersdex.com ***

OK

This means that you want days past 1/1/1900

Knowing this you can use one of the methods I described in my earlier mail.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Sandeep Commar" <s_commar (AT) hotmail (DOT) com> wrote