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) –
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 | Operation | Column) – Timezone. The timezone of the query will be used if no
timezone
was passed.unit (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
Operation obtained from the string- Return type
Examples
>>> 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
>>> 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
>>> 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