vb 6 and oracle problem of fetching date

[dmesh]

i use ADO in VB6 to connect to my Oracle database
i made a connection object 'con' and opened the database using it

when i fetch the date from the table the format is become change .
oracle format is dd/mm/yyyy e.g. 1-sep-2011
and in vb
the format is mm/dd/yyyy e.g. 9/1/2011

i uses text box to enter date to the oracle table.
and DBGrid to fetch the date from oracle table

pls give me some solution about it
please

[debasisdas]

You can format the dates as desired at either Oracle or VB level.