public void UpdateDate(int id, DateTimeOffset modifiedDate) { var q = "UPDATE `songs` SET `modified_date` = @date WHERE `song_id` = @id"; using (var cmd = Connection.CreateCommand()) { cmd.CommandText = q; cmd.Parameters.AddWithValue("@date", modifiedDate.ToUnixTimeSeconds()); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); } }
public static void InitializeRandom(System.DateTimeOffset seedTime) { random = new System.Random((int)seedTime.ToUnixTimeSeconds()); }
private long EpochSeconds() { var _epoch = new System.DateTimeOffset(System.DateTime.UtcNow); return(_epoch.ToUnixTimeSeconds()); }
private double ConvertGregorianToJulian(System.DateTimeOffset gregorianDate) { return(gregorianDate.ToUnixTimeSeconds() / secondsInDay - 0.5 + J1970); }