I'm using Oracle and have some problem about date format.
{
Dim command As New OleDb.OleDbCommand()
command.Connection = connection
command.CommandText = "SELECT COUNT(*) AS COUNT FROM CAR WHERE DATE_KEYIN = '07/07/2003'"
Dim datRead = command.ExecuteReader()
Do Until datRead.Read = False
tb1.Text = datRead(0)
Loop
datRead.Close(
}

I saw the date that was already insert into table is in format 'M/D/YYYY', without hh:mm:ss .
But i search high and low this format is supported in Oracle.
However, it will prompt me ERROR "ORA-01843 Not a valid month"

: I'm using Oracle and have some problem about date format.
: {
: Dim command As New OleDb.OleDbCommand()
: command.Connection = connection
: command.CommandText = "SELECT COUNT(*) AS COUNT FROM CAR WHERE DATE_KEYIN = '07/07/2003'"
: Dim datRead = command.ExecuteReader()
: Do Until datRead.Read = False
: tb1.Text = datRead(0)
: Loop
: datRead.Close(
: }
:
: I saw the date that was already insert into table is in format 'M/D/YYYY', without hh:mm:ss .
: But i search high and low this format is supported in Oracle.
: However, it will prompt me ERROR "ORA-01843 Not a valid month"

I always use "WHERE TO_CHAR(DATE_KEYIN, 'YYYYMMDD') = '20030707'" That's also good for sorting since it's year, month, day.

-Ray