Oracle datetime in VB.net
Posted
by acadia
on Stack Overflow
See other posts from Stack Overflow
or by acadia
Published on 2010-03-17T19:10:13Z
Indexed on
2010/03/17
19:11 UTC
Read the original article
Hit count: 456
I have a Oracle procedure to which I have to pass a datetime value (2/5/2010 11:46 AM) How do I pass this value from VB.net. When I pass the date as shown below it is not returning any records though there are records.
With Cmd
.Connection = FactsConn
.CommandType = CommandType.StoredProcedure
.CommandText = "sp_atas_image_qry"
.Parameters.Add(New OracleParameter("vinspectiondatetime", OracleClient.OracleType.DateTime)).Value = "2/5/2010 11:46 AM"
.Parameters.Add(New OracleParameter("io_cursor", OracleClient.OracleType.Cursor)).Direction = ParameterDirection.Output
End With
© Stack Overflow or respective owner