how to insert date and time in oracle 10g using vb.net coading

Question

0.00/5 (No votes)

See more:

Respected sir/mam

I want to store a date and time in oracle 10g database.
I am trying to inserting a date and time and my vb.net statement is

VB

dsNewRow.Item("date_time") = Format(DateTime.Today, ("yyyy-MM-dd HH:mm:ss.000"))

in the above statement only date is inserting in database. But i want to inserting date as well as time. My date_time fields data type is date.
how it is possible?

Please help me.

Thank You in advance.

Posted 12-Feb-12 20:22pm

Avi Mali

Updated 12-Feb-12 20:34pm

Mehdi Gholam

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

testy_proconsul · Answer 1 · 2012-02-12T21:46:00

I remember, that Oracle "can" handle DateType field values as string. If you write a query the date has to be given as string in the where-clause:

Select * From Employee Where HireDate >= '01-01-2011 00:00:00'

So, it is correct that you put a string value.

Furthermore, you can use the OracleDateTime structure from the Oracle-Namespace when you use the drivers from Oracle and not from Microsoft.

Using the Oracle drivers from Microsoft is not recommended.

how to insert date and time in oracle 10g using vb.net coading

1 solution

Solution 1

Add your solution here

Preview 0

how to insert date and time in oracle 10g using vb.net coading

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us