Sql Date problem
From: fullyii <dfully_at_cox.net>
Date: Mon, 06 Jan 2003 17:00:20 +0000
Message-ID: <2352786.1041872420_at_dbforums.com>
Date: Mon, 06 Jan 2003 17:00:20 +0000
Message-ID: <2352786.1041872420_at_dbforums.com>
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
Received on Mon Jan 06 2003 - 18:00:20 CET