* Dennis Cote:
> From the wikipedia article you cited:
>
> Note: although many references say that the Julian in "Julian day"
> refers to Scaliger's father, Julius Scaliger, in the introduction to
> Book V of his Opus de Emendatione Temporum ("Work on the Emendation of
> Time") he states,
On Apr 7, 2008, at 6:27 PM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> See http://en.wikipedia.org/wiki/Julian_day
>>
>> Note that "Julian" in Julian Day Number and Julian Calendar
>> refer to two different people named Julius. The Julian Day Number
>> Julian is Julius Scaliger, the
D. Richard Hipp wrote:
>
> See http://en.wikipedia.org/wiki/Julian_day
>
> Note that "Julian" in Julian Day Number and Julian Calendar
> refer to two different people named Julius. The Julian Day Number
> Julian is Julius Scaliger, the father of the guy who invented
> the julian day number in
On Apr 6, 2008, at 5:12 PM, John Stanton wrote:
> Not a hack, but the traditional way to store dates and times. Sqlite
> functions use a magic epoch which facilitates the presentation of the
> date and time in the form of the major calendars.
>
> We do not use the Julian calendar these days. It
Not a hack, but the traditional way to store dates and times. Sqlite
functions use a magic epoch which facilitates the presentation of the
date and time in the form of the major calendars.
We do not use the Julian calendar these days. It was supplanted by the
Gregorian in 1582. Julian
Near as I can tell, there's no 'standard' way to store dates.
SQLite's date functions can deal with dates as floating-point julian numbers,
-mm-dd hh:mm:ss strings (with or without the time portion), or Unix time
integers. As arguments to SQLite's date/time functions, Unix times usually
is this just your "hack" or the standard way to do this? I don't need it to
be floating point, since I'm not interested in "when" during the day. and,
to be clear, "julian" is the calendar we all use, right? it's completely 1:1
with the ansi format 2008-04-05 that I mentioned, right?
Thank
sqlfan wrote:
> I'm very new to sqlite but I notice there is no way to mark a column as
> containing dates... What is the standard way to do operations with dates,
> please, and to store dates? Should I try the format 20080405 and do my own
> calculations using my language's standard library?
I'm very new to sqlite but I notice there is no way to mark a column as
containing dates... What is the standard way to do operations with dates,
please, and to store dates? Should I try the format 20080405 and do my own
calculations using my language's standard library? (I'm using Python) or
9 matches
Mail list logo
