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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting Date field into database.

Status
Not open for further replies.
BSchaff

BSchaff

Programmer
Apr 10, 2001
4
US
I am using ADO for database access. I am inserting a row into a table with several columns. The insert works fine, except the date field is not formatted correctly. How do you format the date field in the insert statement?
 
Sort by date Sort by votes
Can you clarify "not formatted properly"? How are you sending the date value? Can you post the SQL or code you are using to update the table?
 
Upvote 0 Downvote
Amazingly willing getting ready to respond to this message with my code sample I got field to format properly. Sorry for the bother.


 
Upvote 0 Downvote
use any of these in your insert statements

format (date,"dd/MM/YYYY")

or format (date,"yyyy/MM/dd")

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
313
sal21
sal21
Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
272
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
511
2009luca
2009luca
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
1K
strongm
strongm
Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
327
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top