Re: Sql Date problem

In Oracle I would do
insert into myTable(column1,column2...) values(... , to_date(20010919,'yyyymmdd')...);
From your example I don't know if the month or the day comes first so it might be:
insert into myTable(column1,column2...) values(... , to_date(20010919,'yyyyddmm')...);

But this is an Oracle newsgroup so we don't support that other product that shall be nameless.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"fullyii" <dfully_at_cox.net> wrote in message
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