syntax:types
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
syntax:types [2016/11/21 21:35] – dmitry | syntax:types [2017/12/23 09:48] – dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
Any value in EasyMorph can be either number or text or boolean or error. Unlike databases, one column of a table in EasyMorph can hold values of different types, similarly to Excel. Although, keep in mind that most [[syntax: | Any value in EasyMorph can be either number or text or boolean or error. Unlike databases, one column of a table in EasyMorph can hold values of different types, similarly to Excel. Although, keep in mind that most [[syntax: | ||
+ | |||
==== Numbers ==== | ==== Numbers ==== | ||
Numbers are either integer or decimal numbers with fixed decimal point. Floating point numbers are not supported. Effective range is (-7.9 x 10< | Numbers are either integer or decimal numbers with fixed decimal point. Floating point numbers are not supported. Effective range is (-7.9 x 10< | ||
Line 15: | Line 16: | ||
< | < | ||
- | To convert text values to numbers see [[syntax: | + | To convert text values to numbers see the [[syntax: |
+ | ==== Dates ==== | ||
+ | Notice that there is no dedicated type for dates in EasyMorph. Instead, as in Excel, dates are numbers, but only formatted as dates. Such number date represents a number of days since January 1st, 1900. For instance 42680 corresponds to November 6th, 2016, because there are 42680 days from January 1st, 1900 to that date. | ||
+ | |||
+ | Dates in expressions can be specified using date literals. A date literal has format # | ||
+ | |||
+ | < | ||
+ | |||
+ | is the same as 42680 and corresponds to November 6th, 2016. Here is an example of date literals in a condition: | ||
+ | |||
+ | < | ||
+ | |||
+ | Because dates are numbers, there is no need in using a special function for adding days. To get the next day just add 1. However, there is a special function for adding months — [[syntax: | ||
==== Text ==== | ==== Text ==== | ||
Line 25: | Line 38: | ||
Note: Ampersand (&) is the text concatenation operator. | Note: Ampersand (&) is the text concatenation operator. | ||
- | To convert | + | To convert |
==== Boolean ==== | ==== Boolean ==== | ||
Line 32: | Line 45: | ||
==== Error ==== | ==== Error ==== | ||
- | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using [[syntax: | + | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using the [[syntax: |
+ | |||
+ | You can also create an error values use the [[syntax: | ||
==== Empty values ==== | ==== Empty values ==== | ||
- | If a table cell has no value - it's so called //empty value//. You can check if a column value is empty using [[syntax: | + | If a table cell has no value - it' |
Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. | Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. |
syntax/types.txt · Last modified: 2021/05/12 07:33 by dmitry