Posted by Erland Sommarskog on 06/29/05 01:00

s commar (scommar@verizon.net) writes:
> I have a Platinum database which stores dates in integer 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.

1) Find out how these values are defined. It looks to me that they are
offsets from some base date.
2) Assuming that it is a base date, look up the dateadd function and
friends in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Re: connectionopen (SeCDoClientHandshake().]SSL Security err
• Prev in forum: Re: Database design pointers (please!)
• Thread view: Re: How do I bring in a date which is in Integar form into a databse as a date form.

[Reply to this message]