/// <summary>
        /// Converts <see cref="NpgsqlTypes.NpgsqlTimeStamp"/> to .NET <see cref="DateTime"/> format.
        /// </summary>
        /// <param name="dt">The datetime to convert from.</param>
        /// <returns>Returns the datetime in <see cref="DateTime"/> format.</returns>
        public static DateTime ToDateTime(this NpgsqlTypes.NpgsqlTimeStamp dt)
        {
            DateTime dtRet = new DateTime(dt.Year, dt.Month, dt.Day, dt.Hours, dt.Minutes, dt.Seconds);

            return(dtRet);
        }
 /// <summary>
 /// Converts .NET <see cref="DateTime"/> to <see cref="NpgsqlTypes.NpgsqlTimeStamp"/> format.
 /// </summary>
 /// <param name="datetime">The .NET datetime to convert from.</param>
 /// <returns>Returns the datetime in <see cref="NpgsqlTypes.NpgsqlTimeStamp"/> format.</returns>
 public static NpgsqlTypes.NpgsqlTimeStamp ToPostgreTimeStamp(this DateTime datetime)
 {
     NpgsqlTypes.NpgsqlTimeStamp t =
         new NpgsqlTypes.NpgsqlTimeStamp(datetime.Year, datetime.Month, datetime.Day, datetime.Hour, datetime.Minute, datetime.Second);
     return(t);
 }