DATETIME on database

Hello!

You mean in SCV file?

I extract DATETIME for system database with this code.

<code>

var db = IR.GetDatabase();

var tag_id = sql.Request('SELECT TAG_ID FROM TAGS_PASSPORT WHERE NAME = "KNX.UPS - Power"').GetRowValue(0,0);
var req = sql.Request('SELECT VALUE FROM FLOAT_TAG_HISTORY WHERE TAG_ID = ' + tag_id);
IR.Log(req.GetRowValue(0,0));

</code>

but i also open a copy of db with an sql viewer.

In same case i have an value in real format.

and if i need search a value by date, what is the correct query?