OraFAQ Forum: Windows » Date Format In VB Code

Home » Infrastructure » Windows » Date Format In VB Code

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date Format In VB Code [message #453544]

Thu, 29 April 2010 10:08

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 20:14:16 CDT 2025