Inheritance diagram for Deveel.Data.Sql.Objects.SqlDateTime:

Public Member Functions
	SqlDateTime (int year, int month, int day)

	SqlDateTime (int year, int month, int day, int hour, int minute, int second, int millisecond)

	SqlDateTime (int year, int month, int day, int hour, int minute, int second, int millisecond, SqlDayToSecond offset)

	SqlDateTime (long ticks)

	SqlDateTime (long ticks, SqlDayToSecond offset)

	SqlDateTime (byte[] bytes)

int IComparable.	CompareTo (object obj)

int IComparable< ISqlObject >.	CompareTo (ISqlObject other)

bool ISqlObject.	IsComparableTo (ISqlObject other)
	Checks if the current object is comparable with the given one. More...

TypeCode IConvertible.	GetTypeCode ()

bool IConvertible.	ToBoolean (IFormatProvider provider)

char IConvertible.	ToChar (IFormatProvider provider)

sbyte IConvertible.	ToSByte (IFormatProvider provider)

byte IConvertible.	ToByte (IFormatProvider provider)

short IConvertible.	ToInt16 (IFormatProvider provider)

ushort IConvertible.	ToUInt16 (IFormatProvider provider)

int IConvertible.	ToInt32 (IFormatProvider provider)

uint IConvertible.	ToUInt32 (IFormatProvider provider)

long IConvertible.	ToInt64 (IFormatProvider provider)

ulong IConvertible.	ToUInt64 (IFormatProvider provider)

float IConvertible.	ToSingle (IFormatProvider provider)

double IConvertible.	ToDouble (IFormatProvider provider)

decimal IConvertible.	ToDecimal (IFormatProvider provider)

DateTime IConvertible.	ToDateTime (IFormatProvider provider)

string IConvertible.	ToString (IFormatProvider provider)

object IConvertible.	ToType (Type conversionType, IFormatProvider provider)

bool	Equals (SqlDateTime other)

override bool	Equals (object obj)

override int	GetHashCode ()

int	CompareTo (SqlDateTime other)

long	ToInt64 ()

byte[]	ToByteArray ()

byte[]	ToByteArray (bool timeZone)

SqlDateTime	Add (SqlDayToSecond interval)
	Adds the given interval of time to this date-time. More...

SqlDateTime	Subtract (SqlDayToSecond interval)
	Subtracts a given interval of time from this date. More...

SqlDateTime	Add (SqlYearToMonth interval)
	Adds the given months to this date. More...

SqlDateTime	Subtract (SqlYearToMonth interval)

SqlDateTime	ToUtc ()

SqlString	ToDateString ()

SqlString	ToTimeString ()

SqlString	ToTimeStampString ()

override string	ToString ()

DateTime	ToDateTime ()

Static Public Member Functions
static bool	operator== (SqlDateTime a, SqlDateTime b)

static bool	operator!= (SqlDateTime a, SqlDateTime b)

static bool	operator> (SqlDateTime a, SqlDateTime b)

static bool	operator< (SqlDateTime a, SqlDateTime b)

static bool	operator>= (SqlDateTime a, SqlDateTime b)

static bool	operator<= (SqlDateTime a, SqlDateTime b)

static SqlDateTime	operator+ (SqlDateTime a, SqlDayToSecond b)

static SqlDateTime	operator- (SqlDateTime a, SqlDayToSecond b)

static SqlDateTime	operator+ (SqlDateTime a, SqlYearToMonth b)

static SqlDateTime	operator- (SqlDateTime a, SqlYearToMonth b)

static SqlDateTime	Parse (string s)

static bool	TryParse (string s, out SqlDateTime value)

static bool	TryParseDate (string s, out SqlDateTime value)

static bool	TryParseTime (string s, out SqlDateTime value)

static bool	TryParseTimeStamp (string s, out SqlDateTime value)

static implicit	operator SqlDateTime (DateTimeOffset?a)

static implicit	operator SqlDateTime (DateTimeOffset a)

static implicit	operator DateTimeOffset? (SqlDateTime a)

static implicit	operator DateTimeOffset (SqlDateTime a)

Public Attributes
const string	TimeStringFormat = "HH:mm:ss.fff zzz"

const string	TimeStampStringFormat = "yyyy-MM-ddTHH:mm:ss.fff zzz"

const string	DateStringFormat = "yyyy-MM-dd"

Static Public Attributes
static readonly SqlDateTime	Null = new SqlDateTime(true)

static readonly string[]	SqlDateFormats

static readonly string[]	SqlTimeStampFormats

static readonly string[]	SqlTimeFormats

static readonly SqlDateTime	MaxDate = new SqlDateTime(9999, 12, 31, 23, 59, 59, 999)

static readonly SqlDateTime	MinDate = new SqlDateTime(1, 1, 1, 0, 0, 0, 0)

Properties
bool	IsNull `[get]`

int	Year `[get]`

int	Month `[get]`

int	Day `[get]`

int	Hour `[get]`

int	Minute `[get]`

int	Second `[get]`

int	Millisecond `[get]`

SqlDayToSecond	Offset `[get]`
	Gets the offset between the date-time instance and the UTC time. More...

static SqlDateTime	Now `[get]`

Properties inherited from Deveel.Data.Sql.Objects.ISqlObject
bool	IsNull `[get]`
	Gets a boolean value indicating if the object is `NULL`. More...

Private Member Functions
	SqlDateTime (bool isNull)

void	AssertNotNull ()

Private Attributes
readonly DateTimeOffset	value

const int	DateSize = 7

const int	TimeStampSize = 11

const int	FullTimeStampSize = 13

Detailed Description

Definition at line 21 of file SqlDateTime.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime	(	int	year,
		int	month,
		int	day
	)

inline

Definition at line 73 of file SqlDateTime.cs.

74 : this(year, month, day, 0, 0, 0, 0, SqlDayToSecond.Zero) {

75 }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime	(	int	year,
		int	month,
		int	day,
		int	hour,
		int	minute,
		int	second,
		int	millisecond
	)

inline

Definition at line 77 of file SqlDateTime.cs.

78 : this(year, month, day, hour, minute, second, millisecond, SqlDayToSecond.Zero) {

79 }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime	(	int	year,
		int	month,
		int	day,
		int	hour,
		int	minute,
		int	second,
		int	millisecond,
		SqlDayToSecond	offset
	)

inline

Definition at line 81 of file SqlDateTime.cs.

             : this() {
             if (year <= 0 || year > 9999)
                 throw new ArgumentOutOfRangeException("year");
             if (month <= 0 || month > 12)
                 throw new ArgumentOutOfRangeException("month");
             if (day <= 0 || day > 31)
                 throw new ArgumentOutOfRangeException("day");
 
             if (hour < 0 || hour > 23)
                 throw new ArgumentOutOfRangeException("hour");
             if (minute < 0 || minute > 59)
                 throw new ArgumentOutOfRangeException("minute");
             if (second < 0 || second > 59)
                 throw new ArgumentOutOfRangeException("second");
             if (millisecond < 0 || millisecond > 999)
                 throw new ArgumentOutOfRangeException("millisecond");
 
             var tsOffset = new TimeSpan(0, offset.Hours, offset.Minutes, 0, 0);
             value = new DateTimeOffset(year, month, day, hour, minute, second, millisecond, tsOffset);
         }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime ( long ticks )

inline

Definition at line 103 of file SqlDateTime.cs.

104 : this(ticks, SqlDayToSecond.Zero) {

105 }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime	(	long	ticks,
		SqlDayToSecond	offset
	)

inline

Definition at line 107 of file SqlDateTime.cs.

             : this() {
             var tsOffset = new TimeSpan(0, offset.Hours, offset.Minutes, 0);
             value = new DateTimeOffset(ticks, tsOffset);
         }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime ( bool isNull )

inlineprivate

Definition at line 113 of file SqlDateTime.cs.

             : this() {
             if (isNull)
                 value = null;
         }

Deveel.Data.Sql.Objects.SqlDateTime.SqlDateTime ( byte[] bytes )

inline

Definition at line 119 of file SqlDateTime.cs.

             : this() {
             var year = ((bytes[0] - 100)*100) + (bytes[1] - 100);
             var month = (int) bytes[2];
             var day = (int) bytes[3];
             var hour = (int) bytes[4] - 1;
             var minute  = (int)bytes[5] - 1;
             var second  = (int)bytes[6] - 1;
             int millis;
             int tzh = 0, tzm = 0;
 
             if (bytes.Length == DateSize) {
                 millis = 0;
             } else {
                 millis = bytes[7] << 24 | bytes[8] << 16 | bytes[9] <<  8 | bytes[10];
                 if (bytes.Length == TimeStampSize) {
                     tzh = tzm = 0;
                 } else {
                     tzh = bytes[11] - 20;
                     tzm = bytes[12] - 60;
                 }
             }
 
             value = new DateTimeOffset(year, month, day, hour, minute, second, millis, new TimeSpan(0, tzh, tzm, 0, 0));
         }

Member Function Documentation

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Add ( SqlDayToSecond interval )

inline

Adds the given interval of time to this date-time.

Parameters

interval The interval of time to add.

This method will return Null if either the given interval is SqlDayToSecond.Null or if this instance is equivalent to NULL.

Returns: Returns an instance of SqlDateTime that is the result of the addition to this date of the given interval of time.

Definition at line 390 of file SqlDateTime.cs.

                                                         {
             if (IsNull)
                 return Null;
             if (interval.IsNull)
                 return this;
 
             var result = value.Value.AddMilliseconds(interval.TotalMilliseconds);
             return new SqlDateTime(result.Ticks);
         }

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Add ( SqlYearToMonth interval )

inline

Adds the given months to this date.

Parameters

interval The month-base interval of time to add.

Returns

See also: SqlYearToMonth

Definition at line 425 of file SqlDateTime.cs.

                                                         {
             if (IsNull)
                 return Null;
             if (interval.IsNull)
                 return this;
 
             var result = value.Value.AddMonths(interval.TotalMonths);
             return new SqlDateTime(result.Ticks);
         }

void Deveel.Data.Sql.Objects.SqlDateTime.AssertNotNull ( )

inlineprivate

Definition at line 157 of file SqlDateTime.cs.

                                      {
             if (value == null)
                 throw new InvalidOperationException();
         }

int IComparable. Deveel.Data.Sql.Objects.SqlDateTime.CompareTo ( object obj )

inline

Definition at line 145 of file SqlDateTime.cs.

                                               {
             return CompareTo((SqlDateTime) obj);
         }

int IComparable<ISqlObject>. Deveel.Data.Sql.Objects.SqlDateTime.CompareTo ( ISqlObject other )

inline

Definition at line 149 of file SqlDateTime.cs.

                                                                 {
             return CompareTo((SqlDateTime) other);
         }

int Deveel.Data.Sql.Objects.SqlDateTime.CompareTo ( SqlDateTime other )

inline

Definition at line 332 of file SqlDateTime.cs.

                                                 {
             if (!value.HasValue && !other.value.HasValue)
                 return 0;
             if (!value.HasValue)
                 return 1;
             if (!other.value.HasValue)
                 return -1;
 
             return value.Value.CompareTo(other.value.Value);
         }

bool Deveel.Data.Sql.Objects.SqlDateTime.Equals ( SqlDateTime other )

inline

Definition at line 317 of file SqlDateTime.cs.

                                               {
             if (IsNull && other.IsNull)
                 return true;
 
             return value.Equals(other.value);
         }

override bool Deveel.Data.Sql.Objects.SqlDateTime.Equals ( object obj )

inline

Definition at line 324 of file SqlDateTime.cs.

                                                 {
             return Equals((SqlDateTime) obj);
         }

override int Deveel.Data.Sql.Objects.SqlDateTime.GetHashCode ( )

inline

Definition at line 328 of file SqlDateTime.cs.

                                           {
             return value == null ? 0 : value.GetHashCode();
         }

TypeCode IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.GetTypeCode ( )

inline

Definition at line 233 of file SqlDateTime.cs.

                                             {
             return TypeCode.DateTime;
         }

bool ISqlObject. Deveel.Data.Sql.Objects.SqlDateTime.IsComparableTo ( ISqlObject other )

inline

Checks if the current object is comparable with the given one.

Parameters

other The other ISqlObject to compare.

Returns: Returns true if the current object is comparable with the given one, false otherwise.

Implements Deveel.Data.Sql.Objects.ISqlObject.

Definition at line 229 of file SqlDateTime.cs.

                                                          {
             return other is SqlDateTime;
         }

static implicit Deveel.Data.Sql.Objects.SqlDateTime.operator DateTimeOffset ( SqlDateTime a )

inlinestatic

Definition at line 572 of file SqlDateTime.cs.

                                                                       {
             if (a == null || a.IsNull)
                 throw new NullReferenceException();
 
             var offset = new TimeSpan(a.Offset.Hours, a.Offset.Minutes, a.Offset.Seconds);
             return new DateTimeOffset(a.Year, a.Month, a.Day, a.Hour, a.Minute, a.Second, a.Millisecond, offset);
         }

static implicit Deveel.Data.Sql.Objects.SqlDateTime.operator DateTimeOffset? ( SqlDateTime a )

inlinestatic

Definition at line 564 of file SqlDateTime.cs.

                                                                        {
             if (a == null || a.IsNull)
                 return null;
 
             var offset = new TimeSpan(a.Offset.Hours, a.Offset.Minutes, a.Offset.Seconds);
             return new DateTimeOffset(a.Year, a.Month, a.Day, a.Hour, a.Minute, a.Second, a.Millisecond, offset);
         }

static implicit Deveel.Data.Sql.Objects.SqlDateTime.operator SqlDateTime ( DateTimeOffset? a )

inlinestatic

Definition at line 551 of file SqlDateTime.cs.

                                                                        {
             if (a == null)
                 return Null;
 
             return a.Value;
         }

static implicit Deveel.Data.Sql.Objects.SqlDateTime.operator SqlDateTime ( DateTimeOffset a )

inlinestatic

Definition at line 558 of file SqlDateTime.cs.

                                                                       {
             var date = a;
             var offset = new SqlDayToSecond(date.Offset.Days, date.Offset.Hours, date.Offset.Minutes, date.Offset.Seconds);
             return new SqlDateTime(date.Year, date.Month, date.Day, date.Hour, date.Minute, date.Second, date.Millisecond, offset);         
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator!=	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 449 of file SqlDateTime.cs.

                                                                      {
             return !(a == b);
         }

static SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.operator+	(	SqlDateTime	a,
		SqlDayToSecond	b
	)

inlinestatic

Definition at line 471 of file SqlDateTime.cs.

                                                                               {
             return a.Add(b);
         }

static SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.operator+	(	SqlDateTime	a,
		SqlYearToMonth	b
	)

inlinestatic

Definition at line 479 of file SqlDateTime.cs.

                                                                               {
             return a.Add(b);
         }

static SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.operator-	(	SqlDateTime	a,
		SqlDayToSecond	b
	)

inlinestatic

Definition at line 475 of file SqlDateTime.cs.

                                                                               {
             return a.Subtract(b);
         }

static SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.operator-	(	SqlDateTime	a,
		SqlYearToMonth	b
	)

inlinestatic

Definition at line 483 of file SqlDateTime.cs.

                                                                               {
             return a.Subtract(b);
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator<	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 457 of file SqlDateTime.cs.

                                                                     {
             return a.CompareTo(b) < 0;
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator<=	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 466 of file SqlDateTime.cs.

                                                                      {
             var i = a.CompareTo(b);
             return i == 0 || i < 0;
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator==	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 445 of file SqlDateTime.cs.

                                                                      {
             return a.Equals(b);
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator>	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 453 of file SqlDateTime.cs.

                                                                     {
             return a.CompareTo(b) > 0;
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.operator>=	(	SqlDateTime	a,
		SqlDateTime	b
	)

inlinestatic

Definition at line 461 of file SqlDateTime.cs.

                                                                      {
             var i = a.CompareTo(b);
             return i == 0 || i > 0;
         }

static SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Parse ( string s )

inlinestatic

Definition at line 487 of file SqlDateTime.cs.

                                                   {
             SqlDateTime date;
             if (!TryParse(s, out date))
                 throw new FormatException(String.Format("Cannot convert string {0} to a valid SQL DATE", s));
 
             return date;
         }

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Subtract ( SqlDayToSecond interval )

inline

Subtracts a given interval of time from this date.

Parameters

interval The interval to subtract from this date.

Returns: Returns an instance of SqlDateTime that is the result of the subtraction of the given interval of time from this date value.

See also: SqlDayToSecond

Definition at line 409 of file SqlDateTime.cs.

                                                              {
             if (IsNull)
                 return Null;
             if (interval.IsNull)
                 return this;
 
             var result = value.Value.AddMilliseconds(-(interval.TotalMilliseconds));
             return new SqlDateTime(result.Ticks);
         }

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Subtract ( SqlYearToMonth interval )

inline

Definition at line 435 of file SqlDateTime.cs.

                                                              {
             if (IsNull)
                 return Null;
             if (interval.IsNull)
                 return this;
 
             var result = value.Value.AddMonths(-interval.TotalMonths);
             return new SqlDateTime(result.Ticks);           
         }

bool IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToBoolean ( IFormatProvider provider )

inline

Definition at line 237 of file SqlDateTime.cs.

                                                               {
             throw new InvalidCastException();
         }

byte IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToByte ( IFormatProvider provider )

inline

Definition at line 249 of file SqlDateTime.cs.

                                                            {
             throw new InvalidCastException();
         }

byte [] Deveel.Data.Sql.Objects.SqlDateTime.ToByteArray ( )

inline

Definition at line 348 of file SqlDateTime.cs.

                                     {
             return ToByteArray(false);
         }

byte [] Deveel.Data.Sql.Objects.SqlDateTime.ToByteArray ( bool timeZone )

inline

Definition at line 352 of file SqlDateTime.cs.

                                                  {
             var size = timeZone ? 13 : 11;
             if (IsNull)
                 return new byte[size];
 
             var bytes = new byte[size];
             bytes[0] = (byte)((Year / 100) + 100);
             bytes[1] = (byte)((Year % 100) + 100);
             bytes[2] = (byte)(Month);
             bytes[3] = (byte)(Day);
             bytes[4] = (byte)(Hour   + 1);
             bytes[5] = (byte)(Minute + 1);
             bytes[6] = (byte)(Second + 1);
             bytes[7] = (byte)((Millisecond >> 24));
             bytes[8] = (byte)((Millisecond >> 16) & 0xff);
             bytes[9] = (byte)((Millisecond >>  8) & 0xff);
             bytes[10]= (byte)(Millisecond & 0xff);
             if (timeZone) {
                 var tsOffset = Offset;
                 bytes[11] = (byte)(tsOffset.Hours + 20);
                 bytes[12] = (byte)(tsOffset.Minutes + 60);
             }
             return bytes;
         }

char IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToChar ( IFormatProvider provider )

inline

Definition at line 241 of file SqlDateTime.cs.

                                                            {
             throw new InvalidCastException();
         }

SqlString Deveel.Data.Sql.Objects.SqlDateTime.ToDateString ( )

inline

Definition at line 589 of file SqlDateTime.cs.

                                         {
             if (value == null)
                 return SqlString.Null;
 
             var s = value.Value.ToString(DateStringFormat, CultureInfo.InvariantCulture);
             return new SqlString(s);
         }

DateTime IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToDateTime ( IFormatProvider provider )

inline

Definition at line 289 of file SqlDateTime.cs.

                                                                    {
             if (value == null)
                 throw new NullReferenceException();
 
             return value.Value.DateTime;
         }

DateTime Deveel.Data.Sql.Objects.SqlDateTime.ToDateTime ( )

inline

Definition at line 620 of file SqlDateTime.cs.

                                      {
             if (value == null)
                 throw new InvalidCastException();
 
             return value.Value.DateTime;
         }

decimal IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToDecimal ( IFormatProvider provider )

inline

Definition at line 285 of file SqlDateTime.cs.

                                                                  {
             throw new NotImplementedException();
         }

double IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToDouble ( IFormatProvider provider )

inline

Definition at line 281 of file SqlDateTime.cs.

                                                                {
             return ToInt64();
         }

short IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToInt16 ( IFormatProvider provider )

inline

Definition at line 253 of file SqlDateTime.cs.

                                                              {
             throw new InvalidCastException();
         }

int IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToInt32 ( IFormatProvider provider )

inline

Definition at line 261 of file SqlDateTime.cs.

                                                            {
             throw new InvalidCastException();
         }

long IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToInt64 ( IFormatProvider provider )

inline

Definition at line 269 of file SqlDateTime.cs.

                                                             {
             return ToInt64();
         }

long Deveel.Data.Sql.Objects.SqlDateTime.ToInt64 ( )

inline

Definition at line 343 of file SqlDateTime.cs.

                               {
             AssertNotNull();
             return value.Value.Ticks;
         }

sbyte IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToSByte ( IFormatProvider provider )

inline

Definition at line 245 of file SqlDateTime.cs.

                                                              {
             throw new NotImplementedException();
         }

float IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToSingle ( IFormatProvider provider )

inline

Definition at line 277 of file SqlDateTime.cs.

                                                               {
             return ToInt64();
         }

string IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToString ( IFormatProvider provider )

inline

Definition at line 296 of file SqlDateTime.cs.

                                                                {
             return ToString();
         }

override string Deveel.Data.Sql.Objects.SqlDateTime.ToString ( )

inline

Definition at line 613 of file SqlDateTime.cs.

                                           {
             if (value == null)
                 return "NULL";
 
             return ToTimeStampString().ToString();
         }

SqlString Deveel.Data.Sql.Objects.SqlDateTime.ToTimeStampString ( )

inline

Definition at line 605 of file SqlDateTime.cs.

                                              {
             if (value == null)
                 return SqlString.Null;
 
             var s = value.Value.ToString(TimeStampStringFormat, CultureInfo.InvariantCulture);
             return new SqlString(s);
         }

SqlString Deveel.Data.Sql.Objects.SqlDateTime.ToTimeString ( )

inline

Definition at line 597 of file SqlDateTime.cs.

                                         {
             if (value == null)
                 return SqlString.Null;
 
             var s = value.Value.ToString(TimeStringFormat, CultureInfo.InvariantCulture);
             return new SqlString(s);
         }

object IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToType	(	Type	conversionType,
		IFormatProvider	provider
	)

inline

Definition at line 300 of file SqlDateTime.cs.

                                                                                   {
             if (conversionType == typeof (long))
                 return ToInt64();
             if (conversionType == typeof (float))
                 return (float) ToInt64();
             if (conversionType == typeof (double))
                 return (double) ToInt64();
 
             if (conversionType == typeof (string))
                 return ToString();
 
             if (conversionType == typeof (byte[]))
                 return ToByteArray();
 
             throw new InvalidCastException();
         }

ushort IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToUInt16 ( IFormatProvider provider )

inline

Definition at line 257 of file SqlDateTime.cs.

                                                                {
             throw new InvalidCastException();
         }

uint IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToUInt32 ( IFormatProvider provider )

inline

Definition at line 265 of file SqlDateTime.cs.

                                                              {
             throw new InvalidCastException();
         }

ulong IConvertible. Deveel.Data.Sql.Objects.SqlDateTime.ToUInt64 ( IFormatProvider provider )

inline

Definition at line 273 of file SqlDateTime.cs.

                                                               {
             return (ulong) ToInt64();
         }

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.ToUtc ( )

inline

Definition at line 580 of file SqlDateTime.cs.

                                    {
             if (value == null)
                 return Null;
 
             var utc = value.Value.ToUniversalTime();
             var offset = new SqlDayToSecond(utc.Offset.Days, utc.Offset.Hours, utc.Offset.Minutes);
             return new SqlDateTime(utc.Year, utc.Month, utc.Day, utc.Hour, utc.Minute, utc.Second, utc.Millisecond, offset);
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.TryParse	(	string	s,
		out SqlDateTime	value
	)

inlinestatic

Definition at line 495 of file SqlDateTime.cs.

                                                                      {
             // We delegate parsing DATE and TIME strings to the .NET DateTime object...
             if (TryParseDate(s, out value))
                 return true;
 
             if (TryParseTime(s, out value))
                 return true;
 
             if (TryParseTimeStamp(s, out value))
                 return true;
 
             value = new SqlDateTime();
             return false;
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.TryParseDate	(	string	s,
		out SqlDateTime	value
	)

inlinestatic

Definition at line 510 of file SqlDateTime.cs.

                                                                          {
             value = new SqlDateTime();
 
             // We delegate parsing DATE and TIME strings to the .NET DateTime object...
             DateTimeOffset date;
             if (DateTimeOffset.TryParseExact(s, SqlDateFormats, CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) {
                 value = new SqlDateTime(date.Year, date.Month, date.Day, 0, 0, 0, 0, SqlDayToSecond.Zero);
                 return true;
             }
 
             return false;
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.TryParseTime	(	string	s,
		out SqlDateTime	value
	)

inlinestatic

Definition at line 523 of file SqlDateTime.cs.

                                                                          {
             value = new SqlDateTime();
 
             // We delegate parsing DATE and TIME strings to the .NET DateTime object...
             DateTimeOffset date;
             if (DateTimeOffset.TryParseExact(s, SqlTimeFormats, CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) {
                 var offset = new SqlDayToSecond(date.Offset.Hours, date.Offset.Minutes,0);
                 value = new SqlDateTime(1, 1, 1, date.Hour, date.Minute, date.Second, date.Millisecond, offset);
                 return true;
             }
 
             return false;           
         }

static bool Deveel.Data.Sql.Objects.SqlDateTime.TryParseTimeStamp	(	string	s,
		out SqlDateTime	value
	)

inlinestatic

Definition at line 537 of file SqlDateTime.cs.

                                                                               {
             value = new SqlDateTime();
 
             // We delegate parsing DATE and TIME strings to the .NET DateTime object...
             DateTimeOffset date;
             if (DateTimeOffset.TryParseExact(s, SqlTimeStampFormats, CultureInfo.InvariantCulture, DateTimeStyles.None, out date)) {
                 var offset = new SqlDayToSecond(date.Offset.Hours, date.Offset.Minutes, 0);
                 value = new SqlDateTime(date.Year, date.Month, date.Day, date.Hour, date.Minute, date.Second, date.Millisecond, offset);
                 return true;
             }
 
             return false;
         }

Member Data Documentation

const int Deveel.Data.Sql.Objects.SqlDateTime.DateSize = 7

private

Definition at line 26 of file SqlDateTime.cs.

const string Deveel.Data.Sql.Objects.SqlDateTime.DateStringFormat = "yyyy-MM-dd"

Definition at line 68 of file SqlDateTime.cs.

const int Deveel.Data.Sql.Objects.SqlDateTime.FullTimeStampSize = 13

private

Definition at line 28 of file SqlDateTime.cs.

readonly SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.MaxDate = new SqlDateTime(9999, 12, 31, 23, 59, 59, 999)

static

Definition at line 70 of file SqlDateTime.cs.

readonly SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.MinDate = new SqlDateTime(1, 1, 1, 0, 0, 0, 0)

static

Definition at line 71 of file SqlDateTime.cs.

readonly SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Null = new SqlDateTime(true)

static

Definition at line 24 of file SqlDateTime.cs.

readonly string [] Deveel.Data.Sql.Objects.SqlDateTime.SqlDateFormats

static

Initial value:

= new[] {
            "yyyy-MM-dd",
            "yyyy MM dd"
        }

Definition at line 30 of file SqlDateTime.cs.

readonly string [] Deveel.Data.Sql.Objects.SqlDateTime.SqlTimeFormats

static

Initial value:

= new[] {
            "HH:mm:ss.fff z",
            "HH:mm:ss.fff zz",
            "HH:mm:ss.fff zzz",
            "HH:mm:ss.fff",
            "HH:mm:ss z",
            "HH:mm:ss zz",
            "HH:mm:ss zzz",
            "HH:mm:ss"
        }

Definition at line 55 of file SqlDateTime.cs.

readonly string [] Deveel.Data.Sql.Objects.SqlDateTime.SqlTimeStampFormats

static

Initial value:

= new[] {
            "yyyy-MM-dd HH:mm:ss.fff",
            "yyyy-MM-dd HH:mm:ss.fff z",
            "yyyy-MM-dd HH:mm:ss.fff zz",
            "yyyy-MM-dd HH:mm:ss.fff zzz",
            "yyyy-MM-dd HH:mm:ss",
            "yyyy-MM-dd HH:mm:ss z",
            "yyyy-MM-dd HH:mm:ss zz",
            "yyyy-MM-dd HH:mm:ss zzz",
            "yyyy-MM-ddTHH:mm:ss.fff",
            "yyyy-MM-ddTHH:mm:ss.fff z",
            "yyyy-MM-ddTHH:mm:ss.fff zz",
            "yyyy-MM-ddTHH:mm:ss.fff zzz",
            "yyyy-MM-ddTHH:mm:ss",
            "yyyy-MM-ddTHH:mm:ss z",
            "yyyy-MM-ddTHH:mm:ss zz",
            "yyyy-MM-ddTHH:mm:ss zzz",
        }

Definition at line 35 of file SqlDateTime.cs.

const int Deveel.Data.Sql.Objects.SqlDateTime.TimeStampSize = 11

private

Definition at line 27 of file SqlDateTime.cs.

const string Deveel.Data.Sql.Objects.SqlDateTime.TimeStampStringFormat = "yyyy-MM-ddTHH:mm:ss.fff zzz"

Definition at line 67 of file SqlDateTime.cs.

const string Deveel.Data.Sql.Objects.SqlDateTime.TimeStringFormat = "HH:mm:ss.fff zzz"

Definition at line 66 of file SqlDateTime.cs.

readonly DateTimeOffset Deveel.Data.Sql.Objects.SqlDateTime.value

private

Definition at line 22 of file SqlDateTime.cs.

Property Documentation

int Deveel.Data.Sql.Objects.SqlDateTime.Day

get

Definition at line 176 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Hour

get

Definition at line 183 of file SqlDateTime.cs.

bool Deveel.Data.Sql.Objects.SqlDateTime.IsNull

get

Definition at line 153 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Millisecond

get

Definition at line 204 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Minute

get

Definition at line 190 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Month

get

Definition at line 169 of file SqlDateTime.cs.

SqlDateTime Deveel.Data.Sql.Objects.SqlDateTime.Now

staticget

Definition at line 221 of file SqlDateTime.cs.

SqlDayToSecond Deveel.Data.Sql.Objects.SqlDateTime.Offset

get

Gets the offset between the date-time instance and the UTC time.

Definition at line 214 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Second

get

Definition at line 197 of file SqlDateTime.cs.

int Deveel.Data.Sql.Objects.SqlDateTime.Year

get

Definition at line 162 of file SqlDateTime.cs.

The documentation for this struct was generated from the following file:

/var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Objects/SqlDateTime.cs

Public Member Functions

Static Public Member Functions

Public Attributes

Static Public Attributes

Properties

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation