/// <summary> /// Constructs a new <b>MySqlDateTime</b> object by copying the current value of the given object. /// </summary> /// <param name="mdt">The <b>MySqlDateTime</b> object to copy.</param> public MySqlDateTime(MySqlDateTime mdt) { year = mdt.Year; month = mdt.Month; day = mdt.Day; hour = mdt.Hour; minute = mdt.Minute; second = mdt.Second; microsecond = 0; millisecond = 0; type = MySqlDbType.DateTime; isNull = false; TimezoneOffset = 0; }
static internal MySqlDateTime Parse(string s) { MySqlDateTime dt = new MySqlDateTime(); return dt.ParseMySql(s); }
static internal MySqlDateTime Parse(string s, Common.DBVersion version) { MySqlDateTime dt = new MySqlDateTime(); return dt.ParseMySql(s); }
private void SerializeText(MySqlPacket packet, MySqlDateTime value) { string val = String.Empty; val = String.Format("{0:0000}-{1:00}-{2:00}", value.Year, value.Month, value.Day); if (type != MySqlDbType.Date) { val = value.Microsecond > 0 ? String.Format("{0} {1:00}:{2:00}:{3:00}.{4:000000}", val, value.Hour, value.Minute, value.Second, value.Microsecond) : String.Format("{0} {1:00}:{2:00}:{3:00} ", val, value.Hour, value.Minute, value.Second); } packet.WriteStringNoNull("'" + val + "'"); }
void IMySqlValue.WriteValue(MySqlPacket packet, bool binary, object value, int length) { MySqlDateTime dtValue; string valueAsString = value as string; if (value is DateTime) dtValue = new MySqlDateTime(type, (DateTime)value); else if (valueAsString != null) dtValue = MySqlDateTime.Parse(valueAsString); else if (value is MySqlDateTime) dtValue = (MySqlDateTime)value; else throw new MySqlException("Unable to serialize date/time value."); if (!binary) { SerializeText(packet, dtValue); return; } if (dtValue.Microsecond > 0) packet.WriteByte(11); else packet.WriteByte(7); packet.WriteInteger(dtValue.Year, 2); packet.WriteByte((byte)dtValue.Month); packet.WriteByte((byte)dtValue.Day); if (type == MySqlDbType.Date) { packet.WriteByte(0); packet.WriteByte(0); packet.WriteByte(0); } else { packet.WriteByte((byte)dtValue.Hour); packet.WriteByte((byte)dtValue.Minute); packet.WriteByte((byte)dtValue.Second); } if (dtValue.Microsecond > 0) { long val = dtValue.Microsecond; for (int x = 0; x < 4; x++) { packet.WriteByte((byte)(val & 0xff)); val >>= 8; } } }
/// <summary> /// Enables the contruction of a <b>MySqlDateTime</b> object by parsing a string. /// </summary> public MySqlDateTime(string dateTime) : this(MySqlDateTime.Parse(dateTime)) { }
int IComparable.CompareTo(object obj) { MySqlDateTime otherDate = (MySqlDateTime)obj; if (Year < otherDate.Year) { return(-1); } else if (Year > otherDate.Year) { return(1); } if (Month < otherDate.Month) { return(-1); } else if (Month > otherDate.Month) { return(1); } if (Day < otherDate.Day) { return(-1); } else if (Day > otherDate.Day) { return(1); } if (Hour < otherDate.Hour) { return(-1); } else if (Hour > otherDate.Hour) { return(1); } if (Minute < otherDate.Minute) { return(-1); } else if (Minute > otherDate.Minute) { return(1); } if (Second < otherDate.Second) { return(-1); } else if (Second > otherDate.Second) { return(1); } if (Microsecond < otherDate.Microsecond) { return(-1); } else if (Microsecond > otherDate.Microsecond) { return(1); } return(0); }
static internal MySqlDateTime Parse(string s, Common.DBVersion version) { MySqlDateTime dt = new MySqlDateTime(); return(dt.ParseMySql(s)); }
static internal MySqlDateTime Parse(string s) { MySqlDateTime dt = new MySqlDateTime(); return(dt.ParseMySql(s)); }
void IMySqlValue.WriteValue(MySqlPacket packet, bool binary, object value, int length) { MySqlDateTime dtValue; string valueAsString = value as string; if (value is DateTime) { dtValue = new MySqlDateTime(type, (DateTime)value); } else if (valueAsString != null) { dtValue = MySqlDateTime.Parse(valueAsString); } else if (value is MySqlDateTime) { dtValue = (MySqlDateTime)value; } else { throw new MySqlException("Unable to serialize date/time value."); } if (!binary) { SerializeText(packet, dtValue); return; } if (dtValue.Microsecond > 0) { packet.WriteByte(11); } else { packet.WriteByte(7); } packet.WriteInteger(dtValue.Year, 2); packet.WriteByte((byte)dtValue.Month); packet.WriteByte((byte)dtValue.Day); if (type == MySqlDbType.Date) { packet.WriteByte(0); packet.WriteByte(0); packet.WriteByte(0); } else { packet.WriteByte((byte)dtValue.Hour); packet.WriteByte((byte)dtValue.Minute); packet.WriteByte((byte)dtValue.Second); } if (dtValue.Microsecond > 0) { long val = dtValue.Microsecond; for (int x = 0; x < 4; x++) { packet.WriteByte((byte)(val & 0xff)); val >>= 8; } } }