computer






 

Question by  Dawn63 (17)

How do you change the date format for insertion into Oracle VB?

 
+6

Answer by  knightmare (1231)

If I understand correctly, you'll need the to_date function. Here's the syntax: to_date('01/01/2001', 'MM/DD/YYYY'). You need a format mask after the comma for it to work. You can use different kinds of format masks as well, such as to_date('01-01-01', 'MM-DD-YY') and many others. These cna be found online. Good luck!

 
You have 50 words left!