Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MeltdownMX
-
Importing DateTime from TXT File
Cool, I figured it out. I was being stupid and not taking out the Single Quotes!! Hate it when that happens. THANKS!!- MeltdownMX
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Importing DateTime from TXT File
Okay, I think I am one step closer, I got the error: Server: Msg 241, Level 16, State 1, Line 13 Syntax error converting datetime from character string. Does my data field have to be a certain type? Right now it is just (char). Should it be varchar? Would that make a difference?- MeltdownMX
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Importing DateTime from TXT File
Hi DBomrrsm, Thanks for the reply. I ran this Query in the Query Analyzer and it does exactly what I need. select cast('20'+Left('050401172100',2)+'-' +substring('050401172100',3,2)+'-' +substring('050401172100',5,2)+' ' +substring('050401172100',7,2)+':' +substring('050401172100',9,2)+':'...- MeltdownMX
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Importing DateTime from TXT File
Hi, We have this text file with Date/Time information in the format of 050401172100. 050401172100 Meaning: 05 - Year 2005 04 - Month April 01 - Day The 1st 17 - 24 Hour time 5p.m. 21 - Minutes 5:21p.m. 00 - Seconds 5:21:00 p.m. We have been trying to figure out how to successfully import...- MeltdownMX
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
