nyway. :)
Jared
>
> Rgrds,
>
> Sony
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, January 16, 2003 12:14 AM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject:
EMAIL PROTECTED]]
> Sent: Thursday, January 16, 2003 12:14 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Date data type
> Importance: High
>
> My guess is that your test data contains two dates with the year 1902.
>
>
> 09:18:49 SQL>
&
2003 12:14 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Date data type
> Importance: High
>
> My guess is that your test data contains two dates with the year 1902.
>
>
> 09:18:49 SQL>
> 09:18:49 SQL>create table d( d date );
>
Title: RE: Date data type
Because in the second select, you are using the wrong mask. Try 'mmyy'.
> -Original Message-
> From: Sony kristanto [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 8:49 PM
> To: Multiple recipients of list ORACLE-L
>
9:18:49 SQL>spool off
09:18:49 SQL>
09:18:49 SQL>set echo off
09:18:49 SQL>
All explanations are in the fine manual.
Jared
Sony kristanto <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/14/2003 08:48 PM
Please respond to ORACLE-L
To: Multiple recipients of
--
Sent: Tuesday, January 14, 2003 11:49 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
Does the date data type is not consistence on oracleDB ?
I have the query below :
Create table test (dt date,
name varchar230));
SQL > Select * from test where
Hi Listers,
Does the date data type is not consistence on oracleDB ?
I have the query below :
Create table test (dt date,
name varchar230));
SQL > Select * from test where dt between '01-DEC-02' and '31-DEC-02'
- it returns 22 rows select