Home » Infrastructure » Windows » Date Format In VB Code
Date Format In VB Code [message #453544] Thu, 29 April 2010 10:08 Go to next message
Messages: 21
Registered: December 2009
Location: US
Junior Member


I am writing a VB Code in Excel. In the User form the User Enters Create Date in MMDDYYYY Format. So In my where Clause I would like to value to be read as DD-MON-YYYY ie. Oracle Date Format.

Can some one give me an example to do that.

Re: Date Format In VB Code [message #453546 is a reply to message #453544] Thu, 29 April 2010 10:19 Go to previous message
Michel Cadot
Messages: 68420
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle has no DATE format. The representation of DATE in a string has a format.
So use TO_DATE to convert a string to a DATE and TO_CHAR to convert a DATE to a string.

Previous Topic: Unable to backup Oracle Control Files ~ Access is Denied (merged)
Next Topic: how to get connectivity between sql server and oracle
Goto Forum:

Current Time: Wed Mar 29 08:57:37 CDT 2023