// sets val as DateTime with Oid oid (PqsqlDbType.Time, PqsqlDbType.TimeTZ) into pqparam_buffer pb internal static void SetDate(IntPtr pb, object val, PqsqlDbType oid) { DateTime dt = (DateTime)val; int year; int month; int day; PqsqlBinaryFormat.GetDate(dt, out year, out month, out day); PqsqlBinaryFormat.pqbf_add_date(pb, year, month, day); }
// adds o as DateTime array element into PQExpBuffer a internal static void SetDateArray(IntPtr a, object o) { DateTime dt = (DateTime)o; int year; int month; int day; PqsqlBinaryFormat.GetDate(dt, out year, out month, out day); PqsqlBinaryFormat.pqbf_set_array_itemlength(a, 4); PqsqlBinaryFormat.pqbf_set_date(a, year, month, day); }
public int WriteDate(DateTime value) { if (mRowInfo == null) { throw new InvalidOperationException($"{nameof(PqsqlCopyFrom)}.{nameof(Start)} must be called before we can write data"); } long begin = LengthCheckReset(); #if CODECONTRACTS Contract.Assume(mRowInfo != null); Contract.Assume(mPos >= 0 && mPos < mRowInfo.Length); #endif PqsqlColInfo ci = mRowInfo[mPos]; if (ci == null) { throw new PqsqlException($"{nameof(PqsqlCopyFrom)}.{nameof(Start)} could not setup column information for column {mPos}"); } PqsqlDbType oid = ci.Oid; if (oid != PqsqlDbType.Date) { throw new PqsqlException($"{nameof(PqsqlCopyFrom)}.{nameof(WriteDate)}: cannot write {PqsqlDbType.Date} into column {mPos} of type {oid}"); } int year; int month; int day; PqsqlBinaryFormat.GetDate(value, out year, out month, out day); PqsqlBinaryFormat.pqbf_set_date(mExpBuf, year, month, day); unsafe { sbyte *val = PqsqlBinaryFormat.pqbf_get_bufval(mExpBuf) + begin; return(PutColumn(val, 4)); } }