Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Convert varchar to datetime

Author  Topic  vreede Starting Member 8 Posts Posted - 2001-09-12 : 02:36:59 Who can help, I would like to convert this field (2001:09:07:12:58:08) into a datetime field using a select statement. Books online is not very clear on this. please help