List dates in order

[stjernvd]

Hi

When I create this table, my dates are not in order...

Dates:

LOAD
Concat(Chr(39) & Date(Floor(date))& Chr(39), ', ' ) As date;
SQL SELECT
date
FROM xxx;

They come out like this '01/09/2015', '02/09/2015', 11/08/2015', and so on...

They dates should be in correct order, how do I fix that?

[MK_QSL · Accepted solution]

Dates:

LOAD
Concat(Chr(39) & Date(Floor(dt_bus))& Chr(39), ', ' ,dt_bus) As dt_bus;

Load

     Date(Floor(TimeStamp#(dt_bus,'DD/MM/YYYY hh:mm:ss')),'YYYY-MM-DD') as dt_bus;

SQL SELECT
dt_bus
FROM TOOLS_DATA_HIST;