Member Avatar for NetHustle

my code is inserting the wrong date into my database

my insert statement is:

"insert into claims (claim_id, claim_amount, claim_date,claim_desc, emp_id)  values (" & CInt(clm_id) & "," CInt(clm_amt) & "," & Date.Today & ", '" & CStr(clm_desc) & "', " & CInt(emp_id) & ")";

in the table itself it doesn't show the current date but shows: "1900/01/08 12:00:00 AM"

Edited by NetHustle because: n/a
  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Change the format of date "yyyy-MM-dd"

str="insert into claims (claim_id, claim_amount, claim_date,claim_desc, emp_id)  values (" & CInt(clm_id) & "," CInt(clm_amt) & ",'" & DateTime.Now.ToString("yyyy-MM-dd") & "', '" & CStr(clm_desc) & "'," & CInt(emp_id) & ")"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.