Re: [sqlite] Data types for date and time functions

On Monday, 25 September, 2017 06:20, R Smith wrote: >On 2017/09/25 10:12 AM, David Wellman wrote: >All of these have pro's and cons. Integer storage is usually most >efficient, but it takes some calculation to interpret, however SQLite >is very efficient at it, but if you

Re: [sqlite] Data types for date and time functions

On 2017/09/25 3:46 PM, R Smith wrote: PS: I refer to "Excel" only, but the problem probably persists in all of MS Office, though I didn't check. Thanks to Igor's post and some quick testing, I can confirm that it seems to only affect Excel, not all of MS Office.

Re: [sqlite] Data types for date and time functions

On 2017/09/25 2:23 PM, Stephan Buchert wrote: I was just going to write that you can easily convert an MS serial date value stored in Sqlite to a date string (using 40777 as example): sqlite> select date('1899-12-31', 40777||' days'); 2011-08-23 However, according to

Re: [sqlite] Data types for date and time functions

On 9/25/2017 8:23 AM, Stephan Buchert wrote: I was just going to write that you can easily convert an MS serial date value stored in Sqlite to a date string (using 40777 as example): sqlite> select date('1899-12-31', 40777||' days'); 2011-08-23 However, according to

Re: [sqlite] Data types for date and time functions

On 2017-09-25 08:19:52, "R Smith" wrote: On 2017/09/25 10:12 AM, David Wellman wrote: C - Storing a string with a date or date and time, typically the standard form is ISO8601 which looks like '-MM-DDTHH:NN:SS.MSS +ZZ:ZZ' with the T optionally being a space and the +

[sqlite] Data types for date and time functions

I fired up an MS Excel 2013 and yes, there 1900-02-29 exists and counts for the serial date value! My original comment was, that also storing in Sqlite the MS serial date values would be possible (as well as Matlab date numbers, etc.), and the Sqlite date/time functions allow quite easily to do

[sqlite] Data types for date and time functions

I was just going to write that you can easily convert an MS serial date value stored in Sqlite to a date string (using 40777 as example): sqlite> select date('1899-12-31', 40777||' days'); 2011-08-23 However, according to

Re: [sqlite] Data types for date and time functions

On 2017/09/25 10:12 AM, David Wellman wrote: Hi, We're designing a new feature which will involve a lot of date/time calculations which we intend to do within the SQLite engine// The question has come up as to how we should store date/time values in our tables? Basically how should

Re: [sqlite] Data types for date and time functions

Internally SQLite stores and process numbers as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. I have not examined the code in any depth but would assume that if you store the data in the same format it would save on any processing overhead for

Re: [sqlite] Data types for date and time functions

David Wellman wrote: > The question has come up as to how we should store date/time values in our > tables? Basically how should we define our date/time columns? SQLite does not have a separate date/time type. If you want to use the built-in date/time function, you can store values in one of

[sqlite] Data types for date and time functions

Hi, We're designing a new feature which will involve a lot of date/time calculations which we intend to do within the SQLite engine. As far as we can tell it has the functions that we need. Basically we'll be loading data into SQLite and performing analysis and calculations using SQL. The

Re: [sqlite] SQL Server 2005 and SQLite data types

On 8 Mar 2010, at 10:33am, Preeti1 wrote: > I want to do some mappings for SQL Server and SQLite data types.I went > through the link http://www.sqlite.org/datatype3.html for the data types.But > still confused with few data type mappings from sql server to sql ce. > Can anyone please tell me

[sqlite] SQL Server 2005 and SQLite data types

for the following sql server datatypes: 1.uinqueidentifier 2.nvarchar 3.float 4.ntext Thanks in advance -- View this message in context: http://old.nabble.com/SQL-Server-2005-and-SQLite-data-types-tp27819465p27819465.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] SQLite data types.

On Sat, Nov 28, 2009 at 10:24 PM, Ted Rolle, Jr. <ster...@gmail.com> wrote: > I'm laboring under a false impression.  I thought that the SQLite data > types were limited to text, integer, float, and something else. > you are under a correct impression. SQLite supports INTE

[sqlite] SQLite data types.

I'm laboring under a false impression. I thought that the SQLite data types were limited to text, integer, float, and something else. On the SQLite site there's Currency, date-time with and without timestamps. Where can I find a listing of these? Ted

Re: [sqlite] SQLite Data types

guyot jerome wrote: Hi, I would like to realize the dialect between SQLite and Hibernate but I need to know the correspondence between the SQLite types and the general types (e.g.:How a boolean type is represented under SQLite). What is that somebody can give myself this piece of

[sqlite] SQLite Data types

Hi, I would like to realize the dialect between SQLite and Hibernate but I need to know the correspondence between the SQLite types and the general types (e.g.:How a boolean type is represented under SQLite). What is that somebody can give myself this piece of information because I

[sqlite] data types

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://www.w3schools.com/sql/sql_create.asp Data types given there http://www.sqlite.org/datatype3.html Data types given here Is it ok to use the SQL data types given by w3schools? Or must I strictly use TEXT, NULL, INTEGER, BLOB, and NUMERIC? - --

[sqlite] Data Types

Hi there,   I am using the PRAGMA command "SHOW_DATATYPES=on".  However, not all of my queries return the datatypes.  Has anyone else experienced this problem?   Regards,Steve

Re: [sqlite] Data types in 2.8.13

Hello, On 8 mar 2004, at 18:47, Dennis Cote wrote: How are you interfacing to SQLite? Are you using the C API directly? If so, are you using sqlite_exec() with a callback function (the callback API), or are you using the sqlite_compile(), sqlite_step(), and sqlite_finalize() (the newer

Re: [sqlite] Data types in 2.8.13

From: "Tito Ciuro" <[EMAIL PROTECTED]> > Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I > wonder because I'm still not getting the data types in the result set. > > I posted a message yesterday and after upgrading to 2.8.13 I'm still > getting the same results. Can someone

[sqlite] Data types in 2.8.13

Hello guys, Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I wonder because I'm still not getting the data types in the result set. I posted a message yesterday and after upgrading to 2.8.13 I'm still getting the same results. Can someone *please* give me some pointers?