DateTime: 日時の操作 ======================== :Version: 3.0 :Scope: global :Named arguments: supported A test library for handling date and time values. ``DateTime`` is a Robot Framework standard library that supports creating and converting date and time values (e.g. `Get Current Date`, `Convert Time`), as well as doing simple calculations with them (e.g. `Subtract Time From Date`, `Add Time To Time`). It supports dates and times in various formats, and can also be used by other libraries programmatically. This library is new in Robot Framework 2.8.5. Table of Contents ------------------------------------------------------- - `Terminology` - `Date formats` - `Time formats` - `Millisecond handling` - `Programmatic usage` - `Shortcuts` - `Keywords` Terminology ------------------------------------------------------- In the context of this library, ``date`` and ``time`` generally have following meanings: - ``date``: An entity with both date and time components but without any timezone information. For example, ``2014-06-11 10:07:42``. - ``time``: A time interval. For example, ``1 hour 20 minutes`` or ``01:20:00``. This terminology differs from what Python's standard [https://docs.python.org/2/library/datetime.html|datetime] module uses. Basically its [https://docs.python.org/2/library/datetime.html#datetime-objects|datetime] and [https://docs.python.org/2/library/datetime.html#timedelta-objects|timedelta] objects match ``date`` and ``time`` as defined by this library. Date formats ------------------------------------------------------- Dates can given to and received from keywords in `timestamp`, `custom timestamp`, `Python datetime` and `epoch time` formats. These formats are discussed thoroughly in subsequent sections. Input format is determined automatically based on the given date except when using custom timestamps, in which case it needs to be given using ``date_format`` argument. Default result format is timestamp, but it can be overridden using ``result_format`` argument. Timestamp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If a date is given as a string, it is always considered to be a timestamp. If no custom formatting is given using ``date_format`` argument, the timestamp is expected to be in [http://en.wikipedia.org/wiki/ISO_8601|ISO 8601] like format ``YYYY-MM-DD hh:mm:ss.mil``, where any non-digit character can be used as a separator or separators can be omitted altogether. Additionally, only the date part is mandatory, all possibly missing time components are considered to be zeros. Dates can also be returned in the same ``YYYY-MM-DD hh:mm:ss.mil`` format by using ``timestamp`` value with ``result_format`` argument. This is also the default format that keywords returning dates use. Milliseconds can be excluded using ``exclude_millis`` as explained in `Millisecond handling` section. Examples:: | ${date1} = | Convert Date | 2014-06-11 10:07:42.000 | | ${date2} = | Convert Date | 20140611 100742 | result_format=timestamp | | Should Be Equal | ${date1} | ${date2} | | ${date} = | Convert Date | 20140612 12:57 | exclude_millis=yes | | Should Be Equal | ${date} | 2014-06-12 12:57:00 | Custom timestamp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ It is possible to use custom timestamps in both input and output. The custom format is same as accepted by Python's [https://docs.python.org/2/library/datetime.html#strftime-strptime-behavior| datatime.strptime] function. For example, the default timestamp discussed in the previous section would match ``%Y-%m-%d %H:%M:%S.%f``. When using a custom timestamp in input, it must be specified using ``date_format`` argument. The actual input value must be a string that matches the specified format exactly. When using a custom timestamp in output, it must be given using ``result_format`` argument. Examples:: | ${date} = | Convert Date | 28.05.2014 12:05 | date_format=%d.%m.%Y %H:%M | | Should Be Equal | ${date} | 2014-05-28 12:05:00.000 | | ${date} = | Convert Date | ${date} | result_format=%d.%m.%Y | | Should Be Equal | ${date} | 28.05.2014 | Python datetime ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Python's standard [https://docs.python.org/2/library/datetime.html#datetime.datetime|datetime] objects can be used both in input and output. In input they are recognized automatically, and in output it is possible to get them by giving ``datetime`` value to ``result_format`` argument. One nice benefit with datetime objects is that they have different time components available as attributes that can be easily accessed using the extended variable syntax. Examples:: | ${datetime} = | Convert Date | 2014-06-11 10:07:42.123 | datetime | | Should Be Equal As Integers | ${datetime.year} | 2014 | | Should Be Equal As Integers | ${datetime.month} | 6 | | Should Be Equal As Integers | ${datetime.day} | 11 | | Should Be Equal As Integers | ${datetime.hour} | 10 | | Should Be Equal As Integers | ${datetime.minute} | 7 | | Should Be Equal As Integers | ${datetime.second} | 42 | | Should Be Equal As Integers | ${datetime.microsecond} | 123000 | Epoch time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Epoch time is the time in seconds since the [http://en.wikipedia.org/wiki/Unix_time|UNIX epoch] i.e. 00:00:00.000 (UTC) 1 January 1970. To give a date in epoch time, it must be given as a number (integer or float), not as a string. To return a date in epoch time, it is possible to use ``epoch`` value with ``result_format`` argument. Epoch time is returned as a floating point number. Notice that epoch time itself is independent on timezones and thus same around the world at a certain time. What local time a certain epoch time matches obviously then depends on the timezone. For example, examples below were tested in Finland but verifications would fail on other timezones. Examples:: | ${date} = | Convert Date | ${1000000000} | | Should Be Equal | ${date} | 2001-09-09 04:46:40.000 | | ${date} = | Convert Date | 2014-06-12 13:27:59.279 | epoch | | Should Be Equal | ${date} | ${1402568879.279} | Earliest supported date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The earliest date that is supported depends on the date format and to some extend on the platform: - Timestamps support year 1900 and above. - Python datetime objects support year 1 and above. - Epoch time supports 1970 and above on Windows with Python and IronPython. - On other platforms epoch time supports 1900 and above or even earlier. Prior to Robot Framework 2.9.2, all formats had same limitation as epoch time has nowadays. Time formats ------------------------------------------------------- Similarly as dates, times can be given to and received from keywords in various different formats. Supported formats are `number`, `time string` (verbose and compact), `timer string` and `Python timedelta`. Input format for time is always determined automatically based on the input. Result format is number by default, but it can be customised using ``result_format`` argument. Number ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Time given as a number is interpreted to be seconds. It can be given either as an integer or a float, or it can be a string that can be converted to a number. To return a time as a number, ``result_format`` argument must have value ``number``, which is also the default. Returned number is always a float. Examples:: | ${time} = | Convert Time | 3.14 | | Should Be Equal | ${time} | ${3.14} | | ${time} = | Convert Time | ${time} | result_format=number | | Should Be Equal | ${time} | ${3.14} | Time string ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Time strings are strings in format like ``1 minute 42 seconds`` or ``1min 42s``. The basic idea of this format is having first a number and then a text specifying what time that number represents. Numbers can be either integers or floating point numbers, the whole format is case and space insensitive, and it is possible to add a minus prefix to specify negative times. The available time specifiers are: - ``days``, ``day``, ``d`` - ``hours``, ``hour``, ``h`` - ``minutes``, ``minute``, ``mins``, ``min``, ``m`` - ``seconds``, ``second``, ``secs``, ``sec``, ``s`` - ``milliseconds``, ``millisecond``, ``millis``, ``ms`` When returning a time string, it is possible to select between ``verbose`` and ``compact`` representations using ``result_format`` argument. The verbose format uses long specifiers ``day``, ``hour``, ``minute``, ``second`` and ``millisecond``, and adds ``s`` at the end when needed. The compact format uses shorter specifiers ``d``, ``h``, ``min``, ``s`` and ``ms``, and even drops the space between the number and the specifier. Examples:: | ${time} = | Convert Time | 1 minute 42 seconds | | Should Be Equal | ${time} | ${102} | | ${time} = | Convert Time | 4200 | verbose | | Should Be Equal | ${time} | 1 hour 10 minutes | | ${time} = | Convert Time | - 1.5 hours | compact | | Should Be Equal | ${time} | - 1h 30min | Timer string ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Timer string is a string given in timer like format ``hh:mm:ss.mil``. In this format both hour and millisecond parts are optional, leading and trailing zeros can be left out when they are not meaningful, and negative times can be represented by adding a minus prefix. To return a time as timer string, ``result_format`` argument must be given value ``timer``. Timer strings are by default returned in full ``hh:mm:ss.mil`` format, but milliseconds can be excluded using ``exclude_millis`` as explained in `Millisecond handling` section. Examples:: | ${time} = | Convert Time | 01:42 | | Should Be Equal | ${time} | ${102} | | ${time} = | Convert Time | 01:10:00.123 | | Should Be Equal | ${time} | ${4200.123} | | ${time} = | Convert Time | 102 | timer | | Should Be Equal | ${time} | 00:01:42.000 | | ${time} = | Convert Time | -101.567 | timer | exclude_millis=yes | | Should Be Equal | ${time} | -00:01:42 | Python timedelta ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Python's standard [https://docs.python.org/2/library/datetime.html#datetime.timedelta|timedelta] objects are also supported both in input and in output. In input they are recognized automatically, and in output it is possible to receive them by giving ``timedelta`` value to ``result_format`` argument. Examples:: | ${timedelta} = | Convert Time | 01:10:02.123 | timedelta | | Should Be Equal | ${timedelta.total_seconds()} | ${4202.123} | Millisecond handling ------------------------------------------------------- This library handles dates and times internally using the precision of the given input. With `timestamp`, `time string`, and `timer string` result formats seconds are, however, rounded to millisecond accuracy. Milliseconds may also be included even if there would be none. All keywords returning dates or times have an option to leave milliseconds out by giving a true value to ``exclude_millis`` argument. If the argument is given as a string, it is considered true unless it is empty or case-insensitively equal to ``false`` or ``no``. Other argument types are tested using same [http://docs.python.org/2/library/stdtypes.html#truth-value-testing|rules as in Python]. Notice that prior to Robot Framework 2.9, all strings except the empty string were considered true. When milliseconds are excluded, seconds in returned dates and times are rounded to the nearest full second. With `timestamp` and `timer string` result formats, milliseconds will also be removed from the returned string altogether. Examples:: | ${date} = | Convert Date | 2014-06-11 10:07:42 | | Should Be Equal | ${date} | 2014-06-11 10:07:42.000 | | ${date} = | Convert Date | 2014-06-11 10:07:42.500 | exclude_millis=yes | | Should Be Equal | ${date} | 2014-06-11 10:07:43 | | ${dt} = | Convert Date | 2014-06-11 10:07:42.500 | datetime | exclude_millis=yes | | Should Be Equal | ${dt.second} | ${43} | | Should Be Equal | ${dt.microsecond} | ${0} | | ${time} = | Convert Time | 102 | timer | exclude_millis=false | | Should Be Equal | ${time} | 00:01:42.000 | | | ${time} = | Convert Time | 102.567 | timer | exclude_millis=true | | Should Be Equal | ${time} | 00:01:43 | | Programmatic usage ------------------------------------------------------- In addition to be used as normal library, this library is intended to provide a stable API for other libraries to use if they want to support same date and time formats as this library. All the provided keywords are available as functions that can be easily imported:: from robot.libraries.DateTime import convert_time def example_keyword(timeout): seconds = convert_time(timeout) # ... Additionally helper classes ``Date`` and ``Time`` can be used directly:: from robot.libraries.DateTime import Date, Time def example_keyword(date, interval): date = Date(date).convert('datetime') interval = Time(interval).convert('number') # ... Add Time To Date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [date, time, result_format=timestamp, exclude_millis=False, date_format=None] Adds time to date and returns the resulting date. Arguments: - ``date:`` Date to add time to in one of the supported `date formats`. - ``time:`` Time that is added in one of the supported `time formats`. - ``result_format:`` Format of the returned date. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. - ``date_format:`` Possible `custom timestamp` format of ``date``. Examples:: | ${date} = | Add Time To Date | 2014-05-28 12:05:03.111 | 7 days | | Should Be Equal | ${date} | 2014-06-04 12:05:03.111 | | | ${date} = | Add Time To Date | 2014-05-28 12:05:03.111 | 01:02:03:004 | | Should Be Equal | ${date} | 2014-05-28 13:07:06.115 | Add Time To Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [time1, time2, result_format=number, exclude_millis=False] Adds time to another time and returns the resulting time. Arguments: - ``time1:`` First time in one of the supported `time formats`. - ``time2:`` Second time in one of the supported `time formats`. - ``result_format:`` Format of the returned time. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. Examples:: | ${time} = | Add Time To Time | 1 minute | 42 | | Should Be Equal | ${time} | ${102} | | ${time} = | Add Time To Time | 3 hours 5 minutes | 01:02:03 | timer | exclude_millis=yes | | Should Be Equal | ${time} | 04:07:03 | Convert Date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [date, result_format=timestamp, exclude_millis=False, date_format=None] Converts between supported `date formats`. Arguments: - ``date:`` Date in one of the supported `date formats`. - ``result_format:`` Format of the returned date. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. - ``date_format:`` Specifies possible `custom timestamp` format. Examples:: | ${date} = | Convert Date | 20140528 12:05:03.111 | | Should Be Equal | ${date} | 2014-05-28 12:05:03.111 | | ${date} = | Convert Date | ${date} | epoch | | Should Be Equal | ${date} | ${1401267903.111} | | ${date} = | Convert Date | 5.28.2014 12:05 | exclude_millis=yes | date_format=%m.%d.%Y %H:%M | | Should Be Equal | ${date} | 2014-05-28 12:05:00 | Convert Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [time, result_format=number, exclude_millis=False] Converts between supported `time formats`. Arguments: - ``time:`` Time in one of the supported `time formats`. - ``result_format:`` Format of the returned time. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. Examples:: | ${time} = | Convert Time | 10 seconds | | Should Be Equal | ${time} | ${10} | | ${time} = | Convert Time | 1:00:01 | verbose | | Should Be Equal | ${time} | 1 hour 1 second | | ${time} = | Convert Time | ${3661.5} | timer | exclude_milles=yes | | Should Be Equal | ${time} | 01:01:02 | Get Current Date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [time_zone=local, increment=0, result_format=timestamp, exclude_millis=False] Returns current local or UTC time with an optional increment. Arguments: - ``time_zone:`` Get the current time on this time zone. Currently only ``local`` (default) and ``UTC`` are supported. - ``increment:`` Optional time increment to add to the returned date in one of the supported `time formats`. Can be negative. - ``result_format:`` Format of the returned date (see `date formats`). - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. Examples:: | ${date} = | Get Current Date | | Should Be Equal | ${date} | 2014-06-12 20:00:58.946 | | ${date} = | Get Current Date | UTC | | Should Be Equal | ${date} | 2014-06-12 17:00:58.946 | | ${date} = | Get Current Date | increment=02:30:00 | | Should Be Equal | ${date} | 2014-06-12 22:30:58.946 | | ${date} = | Get Current Date | UTC | - 5 hours | | Should Be Equal | ${date} | 2014-06-12 12:00:58.946 | | ${date} = | Get Current Date | result_format=datetime | | Should Be Equal | ${date.year} | ${2014} | | Should Be Equal | ${date.month} | ${6} | Subtract Date From Date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [date1, date2, result_format=number, exclude_millis=False, date1_format=None, date2_format=None] Subtracts date from another date and returns time between. Arguments: - ``date1:`` Date to subtract another date from in one of the supported `date formats`. - ``date2:`` Date that is subtracted in one of the supported `date formats`. - ``result_format:`` Format of the returned time (see `time formats`). - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. - ``date1_format:`` Possible `custom timestamp` format of ``date1``. - ``date2_format:`` Possible `custom timestamp` format of ``date2``. Examples:: | ${time} = | Subtract Date From Date | 2014-05-28 12:05:52 | 2014-05-28 12:05:10 | | Should Be Equal | ${time} | ${42} | | ${time} = | Subtract Date From Date | 2014-05-28 12:05:52 | 2014-05-27 12:05:10 | verbose | | Should Be Equal | ${time} | 1 day 42 seconds | Subtract Time From Date ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [date, time, result_format=timestamp, exclude_millis=False, date_format=None] Subtracts time from date and returns the resulting date. Arguments: - ``date:`` Date to subtract time from in one of the supported `date formats`. - ``time:`` Time that is subtracted in one of the supported `time formats`. - ``result_format:`` Format of the returned date. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. - ``date_format:`` Possible `custom timestamp` format of ``date``. Examples:: | ${date} = | Subtract Time From Date | 2014-06-04 12:05:03.111 | 7 days | | Should Be Equal | ${date} | 2014-05-28 12:05:03.111 | | ${date} = | Subtract Time From Date | 2014-05-28 13:07:06.115 | 01:02:03:004 | | Should Be Equal | ${date} | 2014-05-28 12:05:03.111 | Subtract Time From Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Arguments: [time1, time2, result_format=number, exclude_millis=False] Subtracts time from another time and returns the resulting time. Arguments: - ``time1:`` Time to subtract another time from in one of the supported `time formats`. - ``time2:`` Time to subtract in one of the supported `time formats`. - ``result_format:`` Format of the returned time. - ``exclude_millis:`` When set to any true value, rounds and drops milliseconds as explained in `millisecond handling`. Examples:: | ${time} = | Subtract Time From Time | 00:02:30 | 100 | | Should Be Equal | ${time} | ${50} | | ${time} = | Subtract Time From Time | ${time} | 1 minute | compact | | Should Be Equal | ${time} | - 10s |