Why not use the internal Sqlite date format. Then date processing is
straight forward and you can use the conversion routines to present it
in the various national and ISO formats.
Sqlite uses a very correct date storage format based on an epoch way
back in antiquity so that you can present it in any national format.
Using the internal format date comparison is just a numeric compare,
which is efficient.
If you need any special date presentation you can add a custome function
to Sqlite to achieve it from your SQL statement.
RB Smissaert wrote:
Just thought of one reason why it I need something else in SQLite than
yyyymmdd in the date field and that is because I need date comparisons
between different tables. So, I need to do: is fieldA + x days > fieldB?
etc.
This will be difficult with the yyyymmdd format. I could of course update
all the date fields in a VBA loop, but that might be a bit slow. So, if
anybody has an idea how to convert integer yyyymmdd to the Excel date format
in SQLite I would be interested.
RBS
-----Original Message-----
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 03 December 2006 15:37
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Dealing with dates in the format yyyymmdd
I think it is easier to do this in VBA and as the main work is done in a VBA
array it is quite fast as well. Not as elegant maybe as doing it in SQLite,
but it will do.
RBS
-----Original Message-----
From: Fred Williams [mailto:[EMAIL PROTECTED]
Sent: 03 December 2006 14:41
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Dealing with dates in the format yyyymmdd
Is there a reason you can use Excel's "Format Cells" to accomplish what
you wish? Enter a "Custom" format of "yyyy\mm\dd" in a cell and enter
"=today()" as a value in that cell. Have not fooled with Excel much
lately, but I think you can even format a spreadsheet programmatically.
Fred
-----Original Message-----
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 03, 2006 8:21 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Dealing with dates in the format yyyymmdd
When moving data from Interbase to SQLite I have to convert
integer dates in
the format yyyymmdd to Excel dates. These are integer numbers
counting the
days past 31 December 1899. With substr I can make it
dd/mm/yyyy (I am in
the UK and that is the normal way to format dates) but the
problem is it
will be displayed in Excel like mm/dd/yyyy if that would be a
possible date.
This is due to the US date format of Excel.
So, would it be possible in SQLite to make a date format like this:
dd/mmm/yyyy so that would be 03/dec/2006
This would prevent Excel from putting the month first.
or alternatively make it the Excel integer date format so the
above date
would be: 39054
I could handle the date formatting in VBA, but I would like
to do as much as
possible in SQLite as it will be faster and it would keep the
code neater.
Thanks for any advice.
RBS
--------------------------------------------------------------
---------------
To unsubscribe, send email to [EMAIL PROTECTED]
--------------------------------------------------------------
---------------
----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
