Re: Sql Date problem
From: Frank <fbortel_at_home.nl>
Date: Mon, 06 Jan 2003 21:28:59 +0100
Message-ID: <3E19E70B.8030006_at_home.nl>
Date: Mon, 06 Jan 2003 21:28:59 +0100
Message-ID: <3E19E70B.8030006_at_home.nl>
fullyii wrote:
> I recieve a text file with a field that has a text format of 20010910.
> I import this data into sql server 7.0 utilizing the import wizard.
> (The wizard will not convert the data to datetime format) I need to
> know how to convert this data into date format of 2001/09/10. How do I
> do this in sql.
>
> Thank You,
> David A. Fullerton
>
> --
> Posted via http://dbforums.com
Post in the SQL Server group... Not Oracle Received on Mon Jan 06 2003 - 21:28:59 CET