Re: Sql Date problem
From: Jens Fudge <Jens.Fudge_at_archersoft.dk>
Date: Mon, 6 Jan 2003 21:22:09 +0100
Message-ID: <3e19e577$0$71623$edfadb0f_at_dread11.news.tele.dk>
Date: Mon, 6 Jan 2003 21:22:09 +0100
Message-ID: <3e19e577$0$71623$edfadb0f_at_dread11.news.tele.dk>
Why don't you just set the dateformat in a SQL session with SET NLS_DATE or whatever its called (I cannot remember the syntax, sorry)
/Jens Fudge, Archersoft
"fullyii" <dfully_at_cox.net> skrev i en meddelelse
news: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 - 21:22:09 CET