timestamp database

[Alessandro_erc]

Hi all, I´m new user, and i´m using DB toolkit.
I have a database, where the datas have a timestamp, how is possible read this datas in order of time?
For every cicle I need to select six values (three voltages and three currents) in order of timestam.
Thanks to all

[LiciaP]

Hi Alessandro,

you can have a look to this example and this one.

I hope this helps!

Bye,

Licia

[Yamaeda]

SELECT [fields] FROM [table] ORDER BY [timestamp]

/Y

[Ranjeet_Singh]

to make it work make sure the column in which you are wrtiting the time is in datetime format

[Alessandro_erc]

Thanks to all 🙂

[Alessandro_erc]

Thanks to all, now i have the data in order, I have only one other problem, I'm trying to store rows every time into a column array, and i need to refresh this array every time the timestamp change of 20 ms. Because of inside the DB every row of the columns has a different value every 20 millisecond (so inside the column of DB for every timestamp I have 29 rows and if i scroll down the column i have new 29 rows with new timestamp increased of 20 ms)