CODEWITHSUNDEEP
vb.netoracle-database
Adeel Aslam
Adeel Aslam

Reputation: 1294

Oledb Parameter in Vb.net

I am inserting data from vb.net to oracle but I am unable to insert datetime except date into oracle. I want to insert date and also time of entry into database:

cmd.Parameters.Add(":STARTING_DATE", (OleDb.OleDbType.[Date].))
cmd.Parameters(":STARTING_DATE").Value = DateTime.Now()
cmd.Parameters(":STARTING_DATE").Value = txtStartDate.Text

Upvotes: 2

Views: 1069

Answers (1)

Tony Hopkinson
Tony Hopkinson

Reputation: 20320

cmd.Parameters.Add(":STARTING_DATE", (OleDb.OleDbType.[DBTimeStamp].))

apparently.

More info here

MSDN OleDb.OleDbType

Upvotes: 1

Related Questions