SqlLite database,

[hunghnguyen2016]

Hello there

I'm using SqlLite database (NinjaTrader.sqlite). Look at value of Executions table, StatementDate I see this value 638803584000000000

Run this query it always return NULL. Any idea why?
SELECT DATETIME(638803584000000000, 'unixepoch');

[NinjaTrader_ChelseaB]

Hello hunghnguyen2016,

Welcome to the NinjaTrader forums!

Access to the NinjaTrader database is not supported. Unfortunately, our support teams would not be able to assist with this.

This thread will remain open for any community members that would like to provide unsupported code or advice.

[-=Edge=-]

I'm using SqlLite database (NinjaTrader.sqlite). Look at value of Executions table, StatementDate I see this value 638803584000000000

While completely unsupported, this might work for you

while (reader.Read())
{
    string sDate = ((reader["StatementDate"]).ToString());
    Print(sDate + "   =   " + (new DateTime(Convert.ToInt64(sDate)).ToLocalTime()));
}

Forum would not allow me to post the Connection part of the code.
Doesn't like SQLiteConnection in code, hope this little bit might help.


Be Safe in this Crazy World!