Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
order timestamp |
Thu, May 14 2020 4:05 PM | Permanent Link |
Kees Lagendijk | Why doesn't this work?
"Select name, clientno, timeofentry order by timeofentry" timeofentry is a timestamp and the sorting seems to be done at only the first digit, like this: 11-06-2015 23:15:20 22-02-2006 12:25:30 30-03-2008 15:33:26 while I expected 22-02-2006 12:25:30 30-03-2008 15:33:26 11-06-2015 23:15:20 gr, Kees |
Sun, May 17 2020 4:48 PM | Permanent Link |
Kees Lagendijk | Kees Lagendijk wrote:
Why doesn't this work? "Select name, clientno, timeofentry order by timeofentry" timeofentry is a timestamp and the sorting seems to be done at only the first digit, like this: 11-06-2015 23:15:20 22-02-2006 12:25:30 30-03-2008 15:33:26 while I expected 22-02-2006 12:25:30 30-03-2008 15:33:26 11-06-2015 23:15:20 gr, Kees ------------------------ I altered TimeOfEntry into Float and now it works fine gr, Kees |
Sun, May 17 2020 8:34 PM | Permanent Link |
Raul Team Elevate | On 5/14/2020 4:05 PM, Kees Lagendijk wrote:
> Why doesn't this work? > > "Select name, clientno, timeofentry order by timeofentry" > > timeofentry is a timestamp and the sorting seems to be done at only the first digit, like this: > > 11-06-2015 23:15:20 > 22-02-2006 12:25:30 > 30-03-2008 15:33:26 > > while I expected > > 22-02-2006 12:25:30 > 30-03-2008 15:33:26 > 11-06-2015 23:15:20 > Timestamp works fine for me in general and we use it a lot. I threw your sample dates into a table and select with order by returns as expected : 2/22/2006 12:25:30 PM 3/30/2008 3:33:23 PM 11/6/2015 11:15:20 PM Can you do few tings 1. run repair on the table to make sure table is OK 2. provide more info if issue still happening : copy of small table showing the issue would be ideal. Otherwise steps on how to reproduce Raul |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |