Entering data to an sql express db from date time picker

R

reidarT

I have changed from an access db to sql express and use an insert statement
to add data from a datetime picker to the datetime field in the db.
Earlier I had to do some manipulation like "#" & Mid(dteDato,1,2)... to get
the
right format.
I am not sure how to do it with sql, I only get 01.01.1900
reidarT
 
R

raibeart

Try "'" & dteDato) & "'"

In SQL Server you use single quotes around anything other than a
number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date picker coming up in combo when format changed to time 1
VB05 Express Date/Time Picker control 2
Date Time Picker 2
between datetime value from date time picker 3
Problem importing Date Field into SQL DB. 3
help with sql command--quickie hopefully 4
date time picker binding bug 5
Date Time Picker 1

Top