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] -----------------------------------------------------------------------------
