Browse by Tags

DateTime persistence when using UTC doesn't set DateTime.Kind field correctly

I've writen an integration test using NHibernate and System.Data.SQLite writing an entity containing a DateTime field to a database and then reading back the same entity. One of the tests ensures that the DateTime field is the same on the entity when it is read from the database as it is when it...

Posted to Bugs (Forum) by Jack_Hughes on 09-30-2010
Re: DateTime, Ticks & Query Issues

Got it. Here the syntax to make it work select ContactHelper, datetime(StartDate/10000000-62135596800,'unixepoch') as Start, datetime(EndDate/10000000-62135596800,'unixepoch') as End from appointment Thanks to Michael Black (IS) for helping me. please note ContactHelper, StartDate, EndDate...

Posted to General (Forum) by robdal on 07-13-2010
Re: DateTime, Ticks & Query Issues

hi, I'm saving datetime data asSystem. DateTime.Ticks and I'm very happy with it. The only thing I would like to have is something like SELECT datetime(1092941466, 'unixepoch'); it would be something like: SELECT TicksToDateTime(AppointmentStart) where AppointmentStart is an ipothetical...

Posted to General (Forum) by robdal on 07-12-2010
Two Date Inserts -- One works and one fails -- Why? (SOLVED)

I have two insert routines to insert a record into each of two tables. The date field is typed as "Date." The first insert (new member) works while the second one (record attendance) fails. In fact, the VS2010 designer won't let me put in the date type saying it is not a DBType. It also...

Posted to General (Forum) by rkulp on 06-15-2010
Concurrency errors on datatime column

If I include a column in my dataset that I have defined as a datetime data type, I eventually get concurrency errors from the datagridview. The dataset includes as I mentioned a datetime data type. The grid is bound via the usual tableadapter and bindingsource. The grid allows deletes. When the delete...

Posted to Bugs (Forum) by glennwelker on 02-22-2010
Change DateTime Format On Insert

I am using datatables to make large changes to my database, however the datatable class is changing the format of the date, so that when i try to access the data i get the classic "String is not a valid DateTime" error. So i am wondering if there is some SQL that i can use in an INSERT statement...

Posted to How To (Forum) by alex21 on 02-10-2010
How to convert excel datetimes using tableadapter?

Here's my question: I have an SQLite table containing Excel datetimes e.g. 40057.0069444444 (old OLE format), stored in SQlite db in Double format. Now I want to show them in a TableGridView using a tableadapter. This doesn't work because .net can't convert from Double numbers to the .net...

Posted to General (Forum) by andy2m on 01-30-2010
Problems in insert and retriving dates

I am new user of sqlite I have the following table CREATE TABLE Sighting ( SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, SpeciesId integer, LocationId integer, SightingDate date, Note nvarchar(100) ); and the following insert INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) VALUES...

Posted to How To (Forum) by Prachi on 09-11-2009
Re: SQLiteDataAdapter.Fill(datatable)

Leo, I get the same message when using dataAdapter.fill(). While I couldn't solve it properly, i used CREATE TABLE (myDatetimeField TEXT) instead. But it translates time to my timezone (dd/mm/yyyy hh:mm:ss) so i cannot sort on this field. Thus far, i just managed to avoid a program crash What about...

Posted to Bugs (Forum) by Lionel on 08-26-2009
Re: DataType Mappings ("DATETIME" --> DbType.DateTime and "BOOLEAN" --> DbType.Boolean)

Hello, I was using the conversion code from System.Data.SQLite.SQLiteConvert (SQLiteConvert.cs) to convert some types and I'm a bit puzzled over two types: "DATETIME" and "BOOLEAN": The "DATETIME" from/to DbType.DateTime conversion: SQLiteConvert.DbTypeToTypeName( DbType...

Posted to General (Forum) by folderol on 06-25-2009

Page 1 of 2 (16 items) 1 2 Next >