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 infamous 'boolean
dates'! (this was the term that my boss used when he
[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?
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
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 which
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 trivia
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 + 1721436, 'J
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 dates).
After
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 bdate
---
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 app that manages something that my boss
calls: boolean dates.
He told me that exists
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
boss
calls: boolean dates.
He told me that exists an algorithm that manages
dates
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 bdate from paam
sql where rownum 6
BDATE
--
728464
]
10/22/2003 08:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Boolean dates...
Hi to all!
We have an old app that manages something that my boss
calls: boolean dates.
He told me that exists an algorithm
it once a long time ago.
-Original Message-
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
-
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
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
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 according to the format invented by Booleous
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) first 2 digits are the year
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
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('
-
05-JUN-18
Does the above conversion
To: Multiple recipients of list ORACLE-L
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
---
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 app that manages something that my boss
calls: boolean dates.
He told me
Certified 8i
DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003
11:39 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Boolean dates...I
think what your boss really means is 'julian' date. Does he also want hi
-Original Message-
DENNIS WILLIAMS
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. Other
systems define
Julian
: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. Other systems define
Julian differently. IIRC, IBM mainframes call
12:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Boolean dates...
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
Jacques - Thanks very much for looking that up. Since I learned something
new, I'll feel that the day was worthwhile, despite having to spend the day
doing a lot of . . . well, you get the idea. Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
,
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 3:24 PMTo:
Multiple
, 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 something that my boss
calls: boolean dates.
He told me
joseluis_delgadoTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
@yahoo.com cc:
Sent by: Subject: Boolean dates
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 something that my
boss
calls: boolean dates.
He told me that exists an algorithm that manages
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 are strictly
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 bdate from
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's true there has
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Boolean dates...
When, exactly, were the Ides of March?
..
-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
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 :
Kalends
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?
..
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L
37 matches
Mail list logo