# otp.Operation.str.strptime

### strptime(format='%Y/%m/%d %H:%M:%S.%J', timezone=None, unit=None)

Converts the formatted time to the number of nanoseconds (datetime) since 1970/01/01 GMT.

* **Parameters:**
  * **format** ([*str*](https://docs.python.org/3/library/stdtypes.html#str) *,* [*Operation*](../root.md#onetick.py.Operation) *,* [*Column*](../root.md#onetick.py.Column)) -- 

    The format might contain any characters, but the following combinations of
    characters have special meanings

    %Y - Year (4 digits)

    %y - Year (2 digits)

    %m - Month (2 digits)

    %d - Day of month (2 digits)

    %H - Hours (2 digits, 24-hour format)

    %I - Hours (2 digits, 12-hour format)

    %M - Minutes (2 digits)

    %S - Seconds (2 digits)

    %J - Nanoseconds (9 digits)

    %p - AM/PM (2 characters)
  * **timezone** ([*str*](https://docs.python.org/3/library/stdtypes.html#str) *|* [*Operation*](../root.md#onetick.py.Operation) *|* [*Column*](../root.md#onetick.py.Column)) -- Timezone. The timezone of the query will be used if no `timezone` was passed.
  * **unit** ([*str*](https://docs.python.org/3/library/stdtypes.html#str) *,* *optional*) -- If set, format and timezone are ignored.
    If equals to ns, constructs a nanosecond-granularity timestamp from a millisecond-granularity
    string. It has the following format: < milliseconds since 1970/01/01 GMT >.< fraction of a millisecond >.
    The fraction might have at most six digits. If the fraction is equal to zero,
    .< fraction of a millisecond > is optional.
    If equals to ms, constructs a millisecond-granularity timestamp from a millisecond-granularity
    string. It has the following format: < milliseconds since 1970/01/01 GMT >.
* **Returns:**
  [`nsectime`](../../types/nsectime.md#onetick.py.nsectime) Operation obtained from the string
* **Return type:**
  [Operation](../root.md#onetick.py.Operation)

### Examples

```pycon
>>> data = otp.Tick(X='5/17/22-11:10:56.123456789')
>>> data['Y'] = data['X'].str.strptime('%m/%d/%y-%H:%M:%S.%J', 'Europe/London')
>>> otp.run(data)
        Time                           X                             Y
0 2003-12-01  5/17/22-11:10:56.123456789 2022-05-17 06:10:56.123456789
```

```pycon
>>> data = otp.Ticks(A=['1693825877111.002001', '1693825877112'])
>>> data['NSECTIME_A'] = data['A'].str.strptime(unit='ns')
>>> otp.run(data)
                     Time                     A                    NSECTIME_A
0 2003-12-01 00:00:00.000  1693825877111.002001 2023-09-04 07:11:17.111002001
1 2003-12-01 00:00:00.001         1693825877112 2023-09-04 07:11:17.112000000
```

```pycon
>>> data = otp.Tick(A='1693825877111')
>>> data['MSECTIME_A'] = data['A'].str.strptime(unit='ms')
>>> otp.run(data)
        Time              A              MSECTIME_A
0 2003-12-01  1693825877111 2023-09-04 07:11:17.111
```