Forms

How to input date from the user and insert the date in the Oracle table in Visual Basic?

I created a table in Oracle with a field for data type date. I've logged in Visual Basic vb.net form to Oracle using OLE DB Provider for Oracle I placed a textbox in a Form. want to input date from the user and insert the date in the Oracle table created by me in Oracle 9i.

Hello – Well, you still have some work to do here in the VB. If you let your users enter a date in the format they want, you'll have problems. For example, tell me what date this is: 02/05/04 It is June 2, 2004? Or is it February 5, 2004? or perhaps in April 2002 5th? If you have a drop down for day, for another month and another for years, so you always know the next dates in Oracle application. are always in the form day / month / year (dd / Mon / yyyy) then it is easier to handle on the database side. You can choose which format suits your user base, both days (Monday, Tuesday …) or day (01, 02, 03 …) and months may be (01, 02) or month may be January, February … and the year may be 08, 09 or 208 2009 … whatsoever. Say you decide go with the format dd / Mon / yyyy which is something like 02/JUN/2008 when you send this to Oracle, Oracle simply say that you are sending a date and send in this format dd / Mon / yyyy then you should use to_date ('02 / Jun/2008 ',' dd / Mon / yyyy ') Basically Oracle to tell you here to take the entry '02 / Jun/2008 "and convert it to a date (to_date) and is passed as' dd / Mon / yyyy '. Hope this helps