Browse by Tags

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
DataReader can not read DateTime data that was imported with strftime

Hi, I'm a newbee with SQLite and its ADO.Net provider. I'm using 1.0.60 ADO.Net Provider and SQLite 3.6.11 (but I also tried with 3.6.3 and its the same result) I just did migrate the Northwind database to sqlite and I was making some tests. Unfortunately I'm encountering some problems with...

Posted to Bugs (Forum) by silversens on 03-07-2009

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