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

Report message to a moderator

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.

Regards
Michel

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 29 08:57:37 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.