Home » RDBMS Server » Server Administration » '0000/06/19' is correct?
'0000/06/19' is correct? [message #57516] Fri, 20 June 2003 01:20 Go to next message
Eiji Nishikawa
Messages: 1
Registered: June 2003
Junior Member
Hi all,

I executed following SQL.

SQL> select * from datetest;

KEY DATE1
------ -----------
1 0001/06/19
2 -0001/06/19

SQL> select (DATE1-366) from datetest
2 where KEY='1';


(DATE1-366)
-----------
0000/06/18

'0000/06/18' does not exist.
I think '-0001/06/18'.

Thanks,
Eiji

Report message to a moderator

Re: '0000/06/19' is correct? [message #57521 is a reply to message #57516] Fri, 20 June 2003 05:09 Go to previous message
Yasuhiro Ikeda
Messages: 4
Registered: June 2003
Junior Member
see here
You can find a answer.

Report message to a moderator

Previous Topic: Oracle DATE datatype internal structure
Next Topic: How to Calculate Extent Size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:45:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.