Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread order timestamp
Thu, May 14 2020 4:05 PMPermanent 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 PMPermanent 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 PMPermanent Link

Raul

Team Elevate 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

Image