Hubertus wrote:
Dear John,
You might also look at using the Sqlite date format rather than seperate
columns for year, month etc.
That was what I considered first. The problem was, that other people
are also supposed to use this datbase. Some of them use Fortran and they
said that it's easier to compile the data in this format but in the
prefered current_date. I couldn't find a way to do the splitting in day,
month, year with sqlite, so I choose this, admittedly not very nice,
implementation. I think even Fortran should know something like subset or split,
but...
Can this splitting be done by sqlite?
Thank
Hubertus
Sqlite has a set of built in date/time functions which will transform
the internal format according to your requirement. It uses an offset
from an epoch, the standard way to handle dates and times.
The big advantage of the single date/time value is with searching.
There is just a single comparison of a REAL instead of a complex expression.
You could look at using an ISO standard time format like 8601 to
communicate with other users. A VIEW would output you date and time in
that format.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------