PROTECTED]
01/14/2003 08:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Date data type
Hi Listers,
Does the date data type is not consistence on oracleDB ?
I have the query below :
Create table
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
Subject: Date data type
Hi
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 SQLcreate table d( d date );
Table created.
09:18:49 SQL
09:18:49 SQLalter session set nls_date_format = 'mm
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 SQLcreate table d( d date );
Table created.
09:18:49 SQL
09:18:49 SQLalter session set
,
Sony
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[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
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 selected
SQL Select * from test
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 dt between '01-DEC-02' and '31-DEC-02'
- it returns 22 rows selected