Re: [sqlite] SQLite version 3.6.23 - date.c
My apologies everybody. I'm wrong. forget what I said. -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
On 10 March 2010 13:44, Israel Lins Albuquerque wrote: > previous is the 3.6.22 and current is 3.6.23! I think you have them the wrong way round... head -3 sqlite3.c |tail -1 && grep "STR_FUNCTION(current_timestamp" sqlite3.c ** version 3.6.23. By combining all the individual C code files into this STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
previous is the 3.6.22 and current is 3.6.23! The sqlite site says: 'For CURRENT_TIME, the format is HH:MM:SS. For CURRENT_DATE, -MM-DD. The format for CURRENT_TIMESTAMP is "-MM-DD HH:MM:SS".' And looks for me this are changed to: For CURRENT_TIMESTAMP, -MM-DD. The format for CURRENT_DATE is "-MM-DD HH:MM:SS" - Mensagem original - De: "D. Richard Hipp" <d...@hwaci.com> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Quarta-feira, 10 de Março de 2010 10:36:15 Assunto: Re: [sqlite] SQLite version 3.6.23 - date.c On Mar 10, 2010, at 7:36 AM, Israel Lins Albuquerque wrote: > In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > new version > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > I fink this is a problem because: > SELECT CURRENT_DATE will return 2010-03-10 09:34:55 > SELECT CURRENT_TIMESTAMP will return 2010-03-10 > > Are this correct? I think you have it backwards. What you have labeled as "previous version" above is what the current code looks like and your "current version" is what it used to look like. See http://www.sqlite.org/src/ci/eb98265b59 for a diff of the change. This was a bug fix. The code in question only comes into play when you compile with SQLITE_OMIT_DATETIME_FUNCS and so it doesn't matter for most people. We didn't discover the problem until recently when we were adding some tests that make use of SQLITE_OMIT_DATETIME_FUNCS. > > > Regards , > > Israel Lins Albuquerque > Developer > Polibrás Brasil Software Ltda. > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
previous is the 3.6.22 and current is 3.6.23! The sqlite site says: 'For CURRENT_TIME, the format is HH:MM:SS. For CURRENT_DATE, -MM-DD. The format for CURRENT_TIMESTAMP is "-MM-DD HH:MM:SS".' And looks for me this are changed to: For CURRENT_DATE, CURRENT_TIMESTAMP. The format for -MM-DD is "-MM-DD HH:MM:SS". - Mensagem original - De: "D. Richard Hipp" <d...@hwaci.com> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Quarta-feira, 10 de Março de 2010 10:36:15 Assunto: Re: [sqlite] SQLite version 3.6.23 - date.c On Mar 10, 2010, at 7:36 AM, Israel Lins Albuquerque wrote: > In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > new version > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > I fink this is a problem because: > SELECT CURRENT_DATE will return 2010-03-10 09:34:55 > SELECT CURRENT_TIMESTAMP will return 2010-03-10 > > Are this correct? I think you have it backwards. What you have labeled as "previous version" above is what the current code looks like and your "current version" is what it used to look like. See http://www.sqlite.org/src/ci/eb98265b59 for a diff of the change. This was a bug fix. The code in question only comes into play when you compile with SQLITE_OMIT_DATETIME_FUNCS and so it doesn't matter for most people. We didn't discover the problem until recently when we were adding some tests that make use of SQLITE_OMIT_DATETIME_FUNCS. > > > Regards , > > Israel Lins Albuquerque > Developer > Polibrás Brasil Software Ltda. > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
On Mar 10, 2010, at 7:36 AM, Israel Lins Albuquerque wrote: > In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > new version > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > I fink this is a problem because: > SELECT CURRENT_DATE will return 2010-03-10 09:34:55 > SELECT CURRENT_TIMESTAMP will return 2010-03-10 > > Are this correct? I think you have it backwards. What you have labeled as "previous version" above is what the current code looks like and your "current version" is what it used to look like. See http://www.sqlite.org/src/ci/eb98265b59 for a diff of the change. This was a bug fix. The code in question only comes into play when you compile with SQLITE_OMIT_DATETIME_FUNCS and so it doesn't matter for most people. We didn't discover the problem until recently when we were adding some tests that make use of SQLITE_OMIT_DATETIME_FUNCS. > > > Regards , > > Israel Lins Albuquerque > Developer > Polibrás Brasil Software Ltda. > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
> In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, > currentTimeFunc), > > new version > STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d", 0, currentTimeFunc), > STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), > > I fink this is a problem because: > SELECT CURRENT_DATE will return 2010-03-10 09:34:55 > SELECT CURRENT_TIMESTAMP will return 2010-03-10 > > Are this correct? > > > Regards , > > Israel Lins Albuquerque > Developer > Polibrás Brasil Software Ltda. Looks like that was fixed in January: http://www.sqlite.org/src/artifact/485a4409a3 RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF Communications Division assuredcommunications™ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23 - date.c
In this new version: at file date.c line 1095 are changed? Why? previous version STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc), STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), new version STR_FUNCTION(current_timestamp, 0, "%Y-%m-%d", 0, currentTimeFunc), STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), I fink this is a problem because: SELECT CURRENT_DATE will return 2010-03-10 09:34:55 SELECT CURRENT_TIMESTAMP will return 2010-03-10 Are this correct? Regards , Israel Lins Albuquerque Developer Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users