C#

Thank you. I thought the DNS Client. I set the wrong image. I apologize.

Member 11916735 wrote:

1448281492 is an Utc-Date (as a decimal?)

Member 11916735 wrote:

now i will get these date as a date of my time zone

Sascha Lefèvre wrote:

DateTime-

string einstellDatumTemp = item.creationDate.ToString();
int unixTimestamp = int.Parse(einstellDatumTemp);
DateTime unixYear0 = new DateTime(1970, 1, 1);
long unixTimeStampInTicks = unixTimestamp * TimeSpan.TicksPerSecond;
DateTime dtUnix = new DateTime(unixYear0.Ticks + unixTimeStampInTicks);

Member 11916735 wrote:

as a date of my time zone.

command2.CommandText="INSERT INTO hisdet (etb, nobl, poidsb) VALUES (@E, @N, @P)";
command2.Parameters.AddWithValue("@E", etb);
command2.Parameters.AddWithValue("@N", nobl);
command2.Parameters.AddWithValue("@P", poidsb);
command2.ExecuteNonQuery();

command2.CommandText="INSERT INTO hisdet (etb, nobl, poidsb) VALUES (?, ?, ?)";
command2.Parameters.AddWithValue("@E", etb);
command2.Parameters.AddWithValue("@N", nobl);
command2.Parameters.AddWithValue("@P", poidsb);
command2.ExecuteNonQuery();

command2.Parameters.double.tryparse.AddWithValue

const string SourceConnectionString = "DSN=pg_prd;Database=RPD;User Id=postgres;Password=*****;";
const string DestinationConnectionString = "DSN=testing;Database=RPD;User Id=postgres;Password=****;";

DataTable ds1 = new DataTable("ds1");

using (OdbcConnection conn = new OdbcConnection(SourceConnectionString))
using (OdbcCommand command = conn.CreateCommand())
{
    command.CommandText = "Select etb,nobl,poidsb from t_thisdet";
    OdbcDataAdapter MyAdapter = new OdbcDataAdapter(command);
    MyAdapter.Fill(ds1);
}

using (OdbcConnection conn = new OdbcConnection(DestinationConnectionString))
using (OdbcCommand command = conn.CreateCommand())
{
    command.CommandText="INSERT INTO hisdet (etb, nobl, poidsb) VALUES (?, ?, ?)";
    
    conn.Open();
    
    foreach (DataRow row in ds1.Rows)
    {
        command.Parameters.AddWithValue("etb", row["etb"]);
        command.Parameters.AddWithValue("nobl", row["nobl"]);
        command.Parameters.AddWithValue("poidsb", row["poidsb"]);
        
        command.ExecuteNonQuery();
        
        command.Parameters.Clear();
    }
}