'Date format' problems with ASP & Oracle

[cadbilbao]

Hi!

I am using ASP to manage my Oracle 8.0.5 on Windows NT.

I've got a problem, because if I SELECT on SQLPlus, I get:
16-JUL-01.

But if I SELECT on ASP, I get: 16/7/01

So I have to tell users to introduce data in that way: DD-MMM-YY, but they see them DD/MM/YY, and they are usually errors, because they mistype data.

What is your recomendation:
+ Must I change Oracle date format?
+ Or must I change ASP date format?

(wich is the way to change date format on Oracle and ASP?)

Best regards.

 

[gsc1ugs]

I have used "format" in the past, hope this helps

 

[LuvASP]

VBScript doesn't accept "format" by itself so you have to use the "formatdatetime". Look online or in MSDN for this function.

 

[gsc1ugs]

D'OH! vbscript.