I AM USING VB2005 AND SQL SERVER 2000
PVAR_SQL_STR = "INSERT INTO GLR_US_PERIOD (ORG5_CODE,PERIOD_YEAR,PERIOD_CODE,PERIOD_NO,FROM_DATE,TO_DATE,INSERT_USER,INSERT_DATE) VALUES " _
& "('" & PVAR_COMPANY_CODE & "' ,'" & TextBox1.Text & "','" & Serial1.Text & "'," & TextBox2.Text & ", '" + DateTimePicker1.Value.ToString("D") + "' ,'" + DateTimePicker2.Value.ToString("D") + "','" & PVAR_USER_CODE & "','" + Now.ToString("F") + "')"
Syntax error converting datetime from character string
BECAUSE OF THIS PART ONLY
Now.ToString("F")
why i do not know but when i change into
Now.ToString("D")
it works well but it SAVES DATE ONLY
I WANT TO INSERT DATE AND TIME
THANKS