SQL gurus, please help...

I am trying to import a .csv which has date and time in a
column in the format "01Jan00:00:01".

When I specify the field to be datetime in SQL, I get
errors saying that a string cannot be converted to
datetime.

any help would be much appreciated.

thanks,
Raj

Try replacing the Month (Jan, Feb etc) with the proper month digits (01, 02
etc). You probably want to use /'s before and after the month along with
the year such as: 01/01/2003
You also need a space between the year and the beginning of the time like
this: '01/01/2003 00:00:01'


--

Andrew J. Kelly
SQL Server MVP


"rk" <rajkris27 (AT) yahoo (DOT) com> wrote

Hello, rk!

The way i would probablt attack this would be like this

Formatting Character Data into Datetime fields
http://www.sqldts.com/default.aspx?6,103,249,0,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: I am trying to import a .csv which has date and time in a
: column in the format "01Jan00:00:01".

: When I specify the field to be datetime in SQL, I get
: errors saying that a string cannot be converted to
: datetime.

: any help would be much appreciated.

--- Microsoft CDO for Windows 2000