vendredi 2 janvier 2015

Not able to Sort Correctly for some reason using EPOCH in SQLite

Here's my Create Table...



CREATE TABLE TEMPSORT_TABLE
(SortRowID INTEGER PRIMARY KEY,
SortTitle TEXT NOT NULL,
SortPrice INTEGER NOT NULL,
SortDateTime datetime default (('2000-01-01')),
SortTrueDateTime INTEGER NOT NULL)


I have created a simple Table and I have a column called "TrueDateTime" is an INTEGER column and it stores a successfully converted Date that was convered to EPOCH time... Now for SOME unknown reason when I do a simple..


SELECT * FROM THEDB ORDER BY TrueDateTime DESC


It isn't actually sorting correctly by the TrueDateTime column... they are just still random records...


ANY one every have this crazy issue or able to assist me in any way to try and accomplish my goal?


Aucun commentaire:

Enregistrer un commentaire