curious date results
 

Try looking at the regional settings on your machine.

Excel will use these as the default date format. It's likely that oracle is
returning them in mm/dd/yyyy format. If there is a mismatch you will only
notice it with dates like 14/7/03 and not 7/7/03 as 7 is both a valid date &
month.


--

Regards,


Bill Lunney
www.billlunney.com

"andyL" wrote in message
...
I have a curious problem,
I have made an Excel macro command (VB6) with which I run
a select query in an Oracle Database, the query returns a
line from dates in a Excel Sheet, the date format of the
sheet is dd/mm/yyyy hh:mm:ss. The problem is that certain
prices are with error format (mm/dd/yyyy hh:mm:ss)
For example if the results from the beginning of this
month it would supposed to be like:
01/07/2003,02/07/2003...10/07/2003..14/07/2003,15/07/2003
they are appearred to me:
07/01/2003,07/02/2003....07/10/2003...14/072003,15/07/2003
It's anyone out there that knows why this happen?
I hope you understand me cause English is not my native
language.

curious date results
 

My regionals settings are dd/mm/yyyy
the date format in excel is dd/mm/yyyy hh/mm/ss
the sql query in the SQL Plus got not any problem.
The problem is the same
is there any way to stabilise the date from my code???

-----Original Message-----
Try looking at the regional settings on your machine.

Excel will use these as the default date format. It's
likely that oracle is
returning them in mm/dd/yyyy format. If there is a
mismatch you will only
notice it with dates like 14/7/03 and not 7/7/03 as 7 is
both a valid date &
month.


--

Regards,


Bill Lunney
www.billlunney.com

"andyL" wrote in message
...
I have a curious problem,
I have made an Excel macro command (VB6) with which I
run
a select query in an Oracle Database, the query
returns a
line from dates in a Excel Sheet, the date format of the
sheet is dd/mm/yyyy hh:mm:ss. The problem is that
certain
prices are with error format (mm/dd/yyyy hh:mm:ss)
For example if the results from the beginning of this
month it would supposed to be like:

01/07/2003,02/07/2003...10/07/2003..14/07/2003,15/07/2003
they are appearred to me:

07/01/2003,07/02/2003....07/10/2003...14/072003,15/07/2003
It's anyone out there that knows why this happen?
I hope you understand me cause English is not my
native
language.



.