|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Entering data to an sql express db from date time pickerI 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 Try "'" & dteDato) & "'"
In SQL Server you use single quotes around anything other than a number. reidarT wrote: Show quoteHide quote > 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 
Other interesting topics
Alternative to using Bitmap
Really stupid looping problem Startup speed Regex Output to Textbox Urgent! Get rowindex - datagrid navigation Need to capture all keystrokes to my application How to drag a form around the screen? Images in a Windows DataGrid Custom coordinates How open other app from within code? |
|||||||||||||||||||||||
