Thanks that is what I was looking for. Phillip B.
www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 8:34 AM Subject: Re: merge int fields into date > Phillip, > You can nest a series of CASTs to do this. It's not pretty, but > it does work. Here's my test script: > > DECLARE @day int, @month int, @year int, @date datetime > > SELECT @day = 11, @month = 9, @year = 2003 > SET @date = CAST(CAST(@year AS varchar) + '-' + CAST(@month as varchar) + > '-' + CAST(@day AS varchar) AS datetime) > > PRINT @date > > Thanks, > Eric > > > > > "Phillip B" <[EMAIL PROTECTED]> > 09/11/2003 12:45 AM > Please respond to sql > > > To: SQL <[EMAIL PROTECTED]> > cc: > Subject: merge int fields into date > > > I am moving data from a poorly designed table to a new beter table. They > stored the date in the table in three int fields month, day, and year. I > am > going to move the data to a new table with one field that is a date type. > How can I write the query to make the old ints into a date with out using > CF? I tried versions of this but none worked. select month + day+ year as > date > Man Im fried. > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
