DatetimeProperties supported APIs

The following table is structured as follows: The first column contains the method name. The second column is a flag for whether or not there is an implementation in Snowpark for the method in the left column.

Note

Y stands for yes, i.e., supports distributed implementation, N stands for no and API simply errors out, P stands for partial (meaning some parameters may not be supported yet), and D stands for defaults to single node pandas execution via UDF/Sproc.

DatetimeProperties (Series.dt)

Snowpark implemented? (Y/N/P/D)

Notes for current implementation

date

Y

time

Y

timetz

N

year

Y

month

Y

day

Y

hour

Y

minute

Y

second

Y

microsecond

Y

nanosecond

Y

day_of_week

Y

week

N

weekofyear

N

dayofweek

Y

weekday

Y

dayofyear

Y

day_of_year

Y

quarter

Y

is_month_start

Y

is_month_end

Y

is_quarter_start

Y

is_quarter_end

Y

is_year_start

Y

is_year_end

Y

is_leap_year

Y

daysinmonth

Y

days_in_month

Y

tz

N

freq

N

isocalendar

Y

to_period

N

to_pydatetime

N

tz_convert

P

N if timezone format is not supported. Only timezones listed in pytz.all_timezones are supported. For example, UTC is supported but UTC+/-<offset>, such as UTC+09:00, is not supported.

tz_localize

P

N if ambiguous or nonexistent are set to a non-default value. N if timezone format is not supported. Only timezones listed in pytz.all_timezones are supported. For example, UTC is supported but UTC+/-<offset>, such as UTC+09:00, is not supported.

tz_convert

Y

normalize

Y

strftime

N

round

P

N if ambiguous or nonexistent are set to a non-default value.

floor

P

N if ambiguous or nonexistent are set to a non-default value.

ceil

P

N if ambiguous or nonexistent are set to a non-default value.

month_name

P

N if locale is set.

day_name

P

N if locale is set.

total_seconds

Y

to_pytimedelta

N

seconds

Y

days

Y

microseconds

Y

nanoseconds

Y

components

N

qyear

N

start_time

N

end_time

N

end_time

N

to_timestamp

N

unit

N

Language: English