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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Super easy date question

Status
Not open for further replies.
jcoleman

jcoleman

MIS
Dec 24, 2002
87
CA
Hey, Guys.

How the heck do I take a date from a csv file in the format of yyyy/mm/dd and put it into a datetime field in SQL?

Seems simple to me but the %*$&#* gives me an error every time.
 
Sort by date Sort by votes
Never mind, found out that what I thought were null values were actually '8' blank spaces. That kind of doesn't work as a valid date format.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
164
petart
petart
briangriffin
  • Locked
  • Question
Add Current Date to Insert
Replies
2
Views
80
drlex
drlex
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
241
johnb1023
johnb1023
NickyJay
  • Locked
  • Question
Convert date in Varchar field to datetime field - help please!
Replies
1
Views
77
drlex
drlex
Webkins
  • Locked
  • Question
SQL Server 2000 data redundancy question
Replies
1
Views
59
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top