1.11M Members

Store DateTimePicker value to sql serve

 
0
 

Dear Experts

I have applied following custom Format to DateTimePicker

dd-MM-yyyy

So now DateTimePicker is displaying data as

15-01-2010

Sql server 2005, table1 has column named Date with datetime type

How to store DateTimePicker text into date column of Table1

I want to save only date not time as 15-01-2010

Please help

 
0
 

when i do this, my database columns for date use the YYYY-MM-DD format.
you can make yours whatever you like

INSERT INTO table_name ( DATE ) VALUES ( " & vb6.format$(now() "YYYYMMDD") & " )

hope that helps

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article