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
syed.nayeem316
Messages: 21
Registered: December 2009
Location: US
Junior Member

Hi,

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.

Thanks
Syed
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: 68006
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.

Regards
Michel
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: Mon Oct 25 02:46:52 CDT 2021