### Comparison

Following are Comparison operators. You can go into them to get detailed information.

- x > y
- x < y
- x == y
- x <> y or x != y

#### x > y

##### date x > date y

If x is greater than y, the return value will be true. If x is < and == y, the return value will be false.

Example

The return value of the following statement is true.

`ToDate(1999, 10, 10) > ToDate(1999, 2, 5)`

##### datetime x > datetime y

If x is greater than y, the return value will be true. If x is < and == y, the return value will be false.

Example

The return value of the following statement is true.

`ToDateTime(1999, 10, 10, 10, 10, 10) > ToDateTime(1999, 5, 10, 8, 5, 5)`

##### numeric x > numeric y

If x is greater than y, the return value will be true. If x is < and == y, the return value will be false.

Examples

- The return value of the following statement is true.

  `3>2.56`

- The return value of the following statement is false.

  `5.29>7.55`

##### string x > string y

If x is greater than y, the return value will be true. If x is < and == y, the return value will be false.

Examples

- The return value of the following statement is true.

  `"string abcd" > "string abc"`

- The return value of the following statement is false.

  `"string abc" > "string abcd"`

##### time x > time y

If x is greater than y, the return value will be true. If x is < and == y, the return value will be false.

Example

The return value of the following statement is true.

`ToTime(10, 10, 10) > ToTime(8, 10, 10)`

#### x < y

##### date x < date y

If x is less than y, the return value will be true. If x is > and == y, the return value will be false.

Example

The return value of the following statement is false.

`ToDate(1999, 10, 10) < ToDate(1999, 2, 5)`

##### datetime < datetime y

If x is less than y, the return value will be true. If x is > and == y, the return value will be false.

Example

The return value of the following statement is false.

`ToDateTime(1999, 10, 10, 10, 10, 10) < ToDateTime(1999, 5, 10, 8, 5, 5)`

##### numeric x < numeric y

If x is less than y, the return value will be true. If x is > and == y, the return value will be false.

Examples

- The return value of the following statement is true.

  `2.56<3`

- The return value of the following statement is false.

  `7.55<5.88`

##### string x < string y

If x is less than y, the return value will be true. If x is > and == y, the return value will be false.

Examples

- The return value of the following statement is true.

  `"string abc" < "string abcd"`

- The return value of the following statement is false.

  `"string abcd" < "string abc"`

##### time x < time y

If x is less than y, the return value will be true. If x is > and == y, the return value will be false.

Example

The return value of the following statement is false.

`ToTime(10, 10, 10) < ToTime(8, 10, 10)`

#### x == y

##### date x == date y

If x is equal to y, the return value is true. If x is not equal to y, the return value will be false.

Example

The return value of the following statement is false.

`ToDate(1999, 10, 10) == ToDate(1999, 5, 10)`

##### datetime == datetime y

If x is equal to y, the return value will be true. If x is not equal to y, the return value will be false.

Example

The return value of the following statement is false.

`ToDateTime(1999, 10, 10, 5, 10, 10) == ToDateTime(1999,10, 10, 10, 10, 10)`

##### numeric x == numeric y

If x is equal to y, the return value will be true. If x is not equal to y, the return value will be false.

Example

The return value of the following statement is false.

`5==4`

##### string x == string y

If x is equal to y, the return value is true. If x is not equal to y, the return value will be false.

Example

The return value of the following statement is false.

`"string abcd" == "string abc"`

##### time x == time y

If x is equal to y, the return value will be true. If x is not equal to y, the return value will be false.

Example

The return value of the following statement is false.

`ToTime(9, 10, 10) == ToTime(10, 10, 10)`

#### x <> y or x != y

##### date x <> date y or date x != date y

If x is not equal to y, the return value will be true. If x is equal to y, the return value will be false.

Example

The return value of the following statement is true.

`ToDate(1999, 10, 10) != ToDate(1999, 5, 10)`

##### datetime x <> datetime y or datetime x != datetime y

If x is not equal to y, the return value will be true. If x is equal to y, the return value will be false.

Example

The return value of the following statement is true.

`ToDateTime(1999, 10, 10, 5, 10, 10) != ToDateTime(1999,10, 10, 10, 10, 10)`

##### numeric x <> numeric y or numeric x != numeric y

If x is not equal to y, the return value will be true. If x is equal to y, the return value will be false.

Example

The return value of the following statement is false.

`4 <> 4`

##### string x <> string y or string x != string y

If x is not equal to y, the return value will be true. If x is equal to y, the return value will be false.

Example

The return value of the following statement is true.

`"string abc" != "string abcd"`

##### time x <> time y or time x != time y

If x is not equal to y, the return value will be true. If x is equal to y, the return value will be false.

Example

The return value of the following statement is true.

`ToTime(9, 10, 10) <> ToTime(10, 10, 10)`