You are viewing documentation about an older version (1.21.0). View latest version

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

N

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

N

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

N

days_in_month

N

tz

N

freq

N

isocalendar

Y

to_period

N

to_pydatetime

N

tz_localize

N

tz_convert

N

normalize

N

strftime

N

round

N

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

N

to_pytimedelta

N

seconds

N

days

N

microseconds

N

nanoseconds

N

components

N

qyear

N

start_time

N

end_time

N

end_time

N

to_timestamp

N

unit

N