I hope the name of the column in the table - "BDATE" - doesn't stand for "BOOLEAN
DATE" - otherwise you'll have to rename it too, to "JDATE"!
;-)
>>> [EMAIL PROTECTED] 24/10/2003 1:29:41 >>>
List...
I finally found the answer about the
So, it was boss speak, after all. Tell your boss to beware of the
ides of bool.
On 10/23/2003 11:29:41 AM, Jose Luis Delgado wrote:
List...
I finally found the answer about the infamous 'boolean
dates'! (this was the term that my boss used when he
told me about the dates... boolean dat
olean
dates'! (this was the term that my boss used when he
told me about the dates... boolean dates).
After receiving a lot of mails talking about Julian
dates... I started to test in that way.
I could find the following which is the solution to my
problem.
sql> select bdate, to_date(bdate
Title: RE: Boolean dates...
So would that make it meta-trivia?
-Original Message-
From: Michael Milligan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 23, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Boolean dates...
So that's what you call t
List...
I finally found the answer about the infamous 'boolean
dates'! (this was the term that my boss used when he
told me about the dates... boolean dates).
After receiving a lot of mails talking about Julian
dates... I started to test in that way.
I could find the following wh
So that's what you call trivia about trivia? :-) Actually, that is really
interesting.
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 23, 2003 10:55 A
929 (pager, [EMAIL PROTECTED])
[EMAIL PROTECTED]
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 10/22/2003 04:09 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:Re: Boolean dates...
When, exactly, were the Ides of March?
Thanks, Jack! Julian dates were mentioned here and I was just curious.
On 2003.10.22 21:09, [EMAIL PROTECTED] wrote:
The 15th of March.
>From http://www.infoplease.com/spot/ides1.html :
Kalends (1st day of the month)
Nones (the 7th day in March, May, July, and October; the 5th in the ot
Title: Re: Boolean dates...
...and just by way of trivia, the Latin word “kalends” is the only word in that language to start with the letter “K”...
on 10/22/03 6:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
The 15th of March.
From http://www.infoplease.com/spot/ides1.html
-Original Message-
Sent: Thursday, 23 October 2003 01:39
To: Multiple recipients of list ORACLE-L
I think what your boss really means is 'julian' date.
Does he also want his database in mauve?
-
Nice Dilbert reference, Jared. One of my favourites ... stuck prominently on my wall
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Boolean dates...
When, exactly, were the Ides of March?
..
Jared's close. It's 2718 - BC -.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Wednesday, October 22, 2003 3:24 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Boolean dates...
Jared,
If that
When, exactly, were the Ides of March?
On 10/22/2003 04:59:25 PM, Stephane Faroult wrote:
Mladen Gogala wrote:
>
> Nope. It's the dates according to the format invented by Booleous
> Caesar.
Who was counting his days 'ab urbe condita' (753 BC), hence the 700
years shift.
Me thinks he meant 'Julian Dates' but this qualifies for interesting quotes
section in Dilbert newsletter though.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email ar
Guys!...
Thanks a lot to all!
As usual... great list..., great answers!
I'm gonna check the suggestions... just that, doing a
select from that field (using Julian dates) shows the
dates about 500+ years into the future.
Anyway, most of your mails put light into this subject
to me.
Tha
Jose,
In my experience - long ago - managing dates rarely involved Boolean logic,
which is Two Valued Logic, True or False. Instead, they involved MVL
(Multi-Valued Logic) with the most common return value being one of a
bewildering assortment of INDETERMINATE variations, followed by frequent
Mladen Gogala wrote:
>
> Nope. It's the dates according to the format invented by Booleous
> Caesar.
Who was counting his days 'ab urbe condita' (753 BC), hence the 700
years shift.
> On 10/22/2003 12:24:30 PM, [EMAIL PROTECTED] wrote:
> >
> > A
22,
2003 3:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Boolean dates...
Jared's close. It's 2718 - BC -.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet,
DickSent: Wednesday, October 22, 2003
D) or Julian Day Number is the time that has elapsed since
noon January 1, 4713 BC (according to the proleptic Julian calendar; or
November 24, 4714 BC according to the proleptic Gregorian calendar),
expressed in days and fractions of a day.
The Julian day system was intended to provide a single
al;
Jared
"Goulet, Dick" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/22/2003 12:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Boolean d
E-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Boolean dates...
I think this is very perceptive - Julian vs. Boolean. I just want to mention
that what Oracle calls a Julian date is the number of days since Jan 1, 4712
BC. As far as I know, that is exclusive to Oracle.
anuary 1, 4713 BC (according to the proleptic Julian calendar; or November 24, 4714
BC according to the proleptic Gregorian calendar), expressed in days and fractions of
a day.
The Julian day system was intended to provide a single system of dates that could be
used when working with different calendar
Jared,
If that's true there has got to be something a little
"strange" in the way that Oracle computes julian dates. Beacuse
to_date(728,464,'J') returns 05-JUN-2718, where as to_char(sysdate,'J') returns
2,452,935. (comma's added for clari
lect to_date(728283,'J') from dual;
TO_DATE(728
---
06-DEC-2719
And here is the Julian date value for today...
SQL> select to_char(sysdate,'J') from dual;
TO_CHAR
---
2452935
Hope this helps...
-Tim
> Hi to all!
>
&g
Jose
My guess is that your old application has its own format to keep track of
dates. Maybe someone on this list may identify the format from memory,
otherwise my guess is that you will need to figure it out for yourself or
get your hands on that algorithm your boss alluded to. Even with the
Hello Jose,
Do you by chance mean Julian (not Boolean) dates? Oracle
does, in fact, handle those. For example, I just used the
following to convert one of your example dates to dd-Mon-yy
format:
SQL> select to_date('728464','J') from dual;
TO_DATE('
---
I don't think that he's talking about Julian date , but something more convoluted.
Might I ask what system these dates are coming from?? We use to use an ERP system
called ManMan. They calculated dates starting with 1 being 31-October-1971. I
created a function in the database
Boolean Dates is simply boss-speak for Julian Dates. There are probably 20
different ways "Julian Dates" can be encoded into an integer.
various ways I've seen "Julian Dates" have been encoded
1) Days since a specific date (this date varies by implementation)
2)
Oh, that's a bunch of Bool Sheet!
> -Original Message-
> From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 22, 2003 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Boolean dates...
>
>
> Nope. It's the dates a
Hi JL,
try googling for JULIAN dates not boolean. A reason to use Julian dates
could be to allow arithmetic of dates to be either a simple plus or
minus returning the number of days. You still have to convert back and
forth to normal dates for display and human readability. You can see an
get it... it's probably not so complicated... add a 1 at
the beginning, mix up the second and third numbers, something like that.
Have fun and good luck!
Bambi.
-Original Message-
Sent: Wednesday, October 22, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
Are you sure he di
Nope. It's the dates according to the format invented by Booleous
Caesar.
On 10/22/2003 12:24:30 PM, [EMAIL PROTECTED] wrote:
Are you sure he didn't mean Julian dates? Somewhere, someplace you
are
bound to find the algorithm that converts between Julian and
Gregorian
dates.
I think what your boss really means is 'julian' date.
Does he also want his database in mauve?
Try this:
select to_date(bdate,'j') from paam;
That said, the dates in your example are about 700 years
into the future.
Jared
Jose Luis Delgado <[EMAIL PROT
Are you sure he didn't mean Julian dates? Somewhere, someplace you are
bound to find the algorithm that converts between Julian and Gregorian
dates. I had it once a long time ago.
> -Original Message-
>
> Hi to all!
>
> We have an old app that manages so
;- --- Original Message --- -
>From: Jose Luis Delgado
><[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 22 Oct 2003 07:19:26
>
>Hi to all!
>
>We have an old app that manages something that my
>b
to_date(728283,'J') from dual;
TO_DATE(728
---
06-DEC-2719
And here is the Julian date value for today...
SQL> select to_char(sysdate,'J') from dual;
TO_CHAR
---
2452935
Hope this helps...
-Tim
> Hi to all!
>
> We have an old
Hi to all!
We have an old app that manages something that my boss
calls: boolean dates.
He told me that exists an algorithm that manages dates
as a boolean format.
We have several tables in this form:
Note: The following table: PAAM
has the field BDATE defined as NUMBER.
sql> select bd
Hi All,
I am using below code to send mail to Lotus Notes. It works fine except
when I receive a mail message the time stamp is correct. However when
I open the mail message the time stamp in the header is 4 hours off. It
must have something to do with
utl_smtp.write_data(connection, header
Title: RE: dates
SELECT NEXT_DAY(SYSDATE + 7*(rnum-1),'Friday') FROM (SELECT ROWNUM rnum FROM DBA_OBJECTS)
/
Feel free to add a where clause
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN d
I have a table with 1 column. I want to populate it
with the dates of all the fridays for the last 2 years
and the next 2 years from sysdate.
so..
today is 14-JAN-2003
My column will have..
10-jan-2003
03-jan-2003
...
..
17-jan-2003
24-jan-2003
Any ideas?
Cheers
hi!
then i think this is what you need:
select to_date('01-01-'||round(to_char(sysdate, ''), -1),
'DD-MM-') from dual;
reg.
daniel
Imran Ashraf wrote:
>
> Im running this query:
> select round(add_months(sysdate,500),'')
> from dual;
> This retuns:
> 01-JAN-2044.
>
> I want
7;'),-2)
> from dual;
>
> will do.
>
>
> regards
> daniel
>
>
> Imran Ashraf wrote:
> >
> > Hi,
> >
> > how do i round dates like this:
> > Date = 01-01-1996
> > Return = 01-01-2000
> >
> > or
> &
>Hi,
>
>how do i round dates like this:
>Date = 01-01-1996
>Return = 01-01-2000
>
>or
>
>Date = 01-01-1992
>Return = 01-01-1990
>
>
>Thanks.
>
create or replace function decade_round(p_date in date)
return date
is
d_result date;
begin
d_result
_char(sysdate, ''),-2) from dual;
will do.
regards
daniel
Imran Ashraf wrote:
>
> Hi,
>
> how do i round dates like this:
> Date = 01-01-1996
> Return = 01-01-2000
>
> or
>
> Date = 01-01-1992
> Return = 01-01-1990
>
> Thanks.
>
>
Hi,
how do i round dates like this:
Date = 01-01-1996
Return = 01-01-2000
or
Date = 01-01-1992
Return = 01-01-1990
Thanks.
__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
--
Please see
bject: RE:
oracle 9i desupport dates
Wait a min... Apps isn't even certified on
9.2 yet!
April Wells Oracle DBA Keep
yourself well oiled with life, laughter, new ideas and action. Otherwise
you will rust out. _Anonymous
-Original Message-From: JOE TEST
PROTECTED]]
> *Sent:* Tuesday, October 08, 2002 4:59 PM
> *To:* Multiple recipients of list ORACLE-L
> *Subject:* oracle 9i desupport dates
>
> 9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003.
> <-- yes in like 8 months
>
> 9.2, aka9ir
desupport dates
Yes. 9i
Release 2 is the final version of 9i. That’s why it’s desupport date is so much
further out.
Bill
Carle
AT&T
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
-Original
Message-From: Boivin,
Patrice J [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08,
Title: RE: oracle 9i Desupport dates
I figured as much, but with the rate at which Oracle is releasing new versions it just might be.
Rodd
On Tue, 2002-10-08 at 16:39, Jamadagni, Rajendra wrote:
oops that's what happens when you are refreshing 3 databases on three mac
Title: RE: oracle 9i Desupport dates
oops that's what happens when you are refreshing 3 databases on three machines.
Please read it as 9203 ... due out Feb/03.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendr
Oracle 29? We are wy behind the upgrade curve. Yikes. ;-^)
On Tue, 2002-10-08 at 15:54, Jamadagni, Rajendra wrote:
... and 2903 is schedules for Feb03.
Raj
__
--
Rodd Holman
Enterprise Data Systems Engineer
Lod
Is that a new requirement for the OraStaff DBA position?
>>> [EMAIL PROTECTED] 10/08/02 04:33PM >>>
Good. Is anybody here ORacle12i certified?
-Original Message-
Sent: Tuesday, October 08, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
9.01, aka 9ir1 Error correction support(ECS
r 08, 2002
3:34 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: oracle 9i desupport
dates
Will 9i
Release 2 be the final version for 9i?
Patrice Boivin
Systems Analyst
(Oracle Certified DBA)
Systems Admin
& Operations | Admin. et Exploit. des systèmes
Technology
x27;t reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having
an opinion is an art!
-Original Message-From: Boivin, Patrice J
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002
4:34 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: oracle 9i desupport
Good. Is anybody here ORacle12i
certified?
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 3:59
PMTo: Multiple recipients of list ORACLE-LSubject:
oracle 9i desupport dates
9.01, aka 9ir1 Error correction support(ECS) ends jun
Maritimes Region,
DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 4:59
PMTo: Multiple recipients of list ORACLE-LSubject:
oracle 9i desupport dates
9.01, aka 9ir1 Error c
er 08, 2002 2:59
PMTo: Multiple recipients of list ORACLE-LSubject:
oracle 9i desupport dates
9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003.
<-- yes in like 8 months
9.2, aka9ir2, ECS ends sep 30, 2005.
joe
CSUA 2002: Imagine the Possibilities!
Corporate System
9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003.
<-- yes in like 8 months
9.2, aka9ir2, ECS ends sep 30, 2005.
joe
- Original Message -
>
> Does anyone know the release dates for Oracle versions starting from
8.0.5,
> 8.0.6 to 9i.
>
they are different for depending on OS and Oracle edition (SE/EE)
u can check Metalink for the Product Availability Reports (from "Product
Lifec
Hi All,
Does anyone know the release dates for Oracle versions starting from 8.0.5,
8.0.6 to 9i.
Appreciate your help.
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Wednesday, December 19, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject:sql loader-dates
Hi ,
In my data file i have dates in the format e.g. 12/19/2001, but when loader
tries to insert this into the table , the table is expecting date in the
format 19-DEC-01
so it reject
0:45AM >>>
Hi ,
In my data file i have dates in the format e.g. 12/19/2001, but when loader
tries to insert this into the table , the table is expecting date in the
format 19-DEC-01
so it rejects the data.
What can i do to get around this?
regards
--
Please see the official ORACLE-L
Hi ,
In my data file i have dates in the format e.g. 12/19/2001, but when loader
tries to insert this into the table , the table is expecting date in the
format 19-DEC-01
so it rejects the data.
What can i do to get around this?
regards
--
Please see the official ORACLE-L FAQ: http
Hello,
Is there any way to see the dates in which the 'sql' statements from
v$sqlarea view have been inserted?
A lot of thanks,
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de Boecillo p.20
Beatriz,
Take a look at the column FIRST_LOAD_TIME in the V$SQLAREA view..
HTH
Mark
-Original Message-
Martinez Jimenez
Sent: Tuesday, September 25, 2001 16:05
To: Multiple recipients of list ORACLE-L
Hello,
Is there any way to see the dates in which the 'sql' stateme
THANK YOU SO MUCH .
BUNYAMIN
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 7:21 PM
> Is this what you are looking for:
>
> select activity_date from (select activity_date from
> sbc order by activity_date desc)
> wh
Remember that the Order by in the imbeded table in the from is not valid on
8.0.5 (and probably before). At least it does not work for me.
-Original Message-
Sent: Monday, August 06, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
Is this what you are looking for:
select
Bunyamin,
You could use the Top-N SQL technique if you are using Oracle 8i.
Try SELECT * FROM (SELECT * FROM yourtable ORDER BY datefield DESC)
WHERE ROWNUM <= 2
HTH
Shailesh
-Original Message-
Sent: Monday, August 06, 2001 11:52 AM
To: Multiple recipients of list ORACLE
Is this what you are looking for:
select activity_date from (select activity_date from
sbc order by activity_date desc)
where rownum < 3
-Original Message-
Sent: Monday, August 06, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
I have a date field and I want to select rows
I have a date field and I want to select rows
with max 2 date values.
How can I do that?
Thank you.
Well at least that explains my empty inbox. I thought they didn't want me :)
>From: John Kanagaraj <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: OOW - notification of selection - Date
To all prospective OOW presenters!
A delay in OOW's selection notifications - they were supposed to announce
this today. Cut-and-paste from the FAQ:
Q: How can I become a presenter?
A: The Call for Presentations for Oracle OpenWorld San Francisco is now
closed. Notification of selection will be
72 matches
Mail list logo