Class DateUtil

class ooodev.utils.date_time_util.DateUtil[source]

Date and time utilities

classmethod calc_to_date(value)[source]

Get date from calc value

Parameters:: value (float) – Float value from cell
Returns:: Date object, the current local date.
Return type:: datetime.date

See also

See Python date

static date_from_number(value)[source]

Converts a float value to corresponding datetime instance.

Parameters:: value (Number) – number to convert to date and time
Raises:: TypeError – If value is not correct type.
Returns:: Date time instance on success; Otherwise, None
Return type:: datetime

static date_time_str(dt)[source]

Returns a formatted date and time as string.

Method is Lo Instance Safe for use with multiple documents.

Parameters:: dt (datetime) – date time
Returns:: formatted date string such as Jun 05, 2022 20:15
Return type:: str

static date_to_number(date)[source]

Converts a date or datetime instance to a corresponding float value.

Parameters:: date (datetime | date) – date or date time to convert to float
Raises:: TypeError – If date is not a correct type.
Returns:: date as float on success; Otherwise, None
Return type:: float

classmethod date_to_uno_date(date)[source]

Converts a date representation into the com.sun.star.util.DateTime date format Acceptable boundaries: year >= 1900 and <= 32767

Parameters:: date (Any) – datetime.datetime, datetime.date, datetime.time, float (time.time) or time.struct_time
Returns:: A com.sun.star.util.Time if conversion was successful; Otherwise, date
Return type:: Date

static date_to_uno_date_time(date)[source]

Converts a date representation into the com.sun.star.util.DateTime date format Acceptable boundaries: year >= 1900 and <= 32767

Parameters:: date (Any) – datetime.datetime, datetime.date, datetime.time, float (time.time) or time.struct_time
Returns:: A com.sun.star.util.DateTime if conversion was successful; Otherwise, date
Return type:: DateTime

classmethod datetime(year, month, day, hours, minutes, seconds)[source]

Get datetime from year, month, day, hours, minutes and seconds

Parameters:

year (int) – Year
month (int) – Month
day (int) – Day
hours (int) – Hours
minutes (int) – Minutes
seconds (int) – Seconds

Returns:

Datetime object

Return type:

datetime.datetime

classmethod end(get_seconds=True)[source]

End counter

Parameters:: get_seconds (bool) – If return value in total seconds.
Returns:: Return the timedelta or total seconds.
Return type:: timedelta | int

classmethod start()[source]: Start counter

classmethod str_date_time(uno_dt)[source]

Returns a formatted date and time as string.

Method is Lo Instance Safe for use with multiple documents.

Parameters:: uno_dt (datetime) – date time
Returns:: formatted date string such as Jun 05, 2022 20:15 or empty string if uno_dt is null.
Return type:: str

classmethod time(hours, minutes, seconds)[source]

Get time from hour, minutes, seconds

Parameters:

hours (int) – Hours
minutes (int) – Minutes
seconds (int) – Seconds

Returns:

Time object

Return type:

datetime.time

static time_from_number(value)[source]

Converts a float value to corresponding time instance.

Only Hours, Minutes and seconds are are used in conversion.

Parameters:: value (Number) – Number such a float or int to convert
Raises:: TypeError – If value is not correct type.
Returns:: Value as time on success; Otherwise, None
Return type:: time | None

static time_stamp(tz=None)[source]

Gets a time stamp string

Parameters:: tz (timezone | None, optional) – TimeZone
Returns:: Formatted timestamp such as 2022-06-19 17:12:38
Return type:: str

static time_to_number(time)[source]

Converts a time instance to a corresponding float value.

Only Hours, Minutes and seconds are are used in conversion.

Parameters:: time (datetime.time) – time to convert
Raises:: TypeError – If date is not a correct type.
Returns:: time as float on success; Otherwise, None
Return type:: float

classmethod time_to_uno_time(time)[source]

Converts a python time to UNO Time struct instance

Parameters:: time (UnoTime) – Python time
Returns:: UNO Time struct
Return type:: Time

static uno_date_to_date(uno_date)[source]

Converts a uno Date struct to a datetime instance

Parameters:: uno_date (UnoDate) – uno Date struct
Returns:: Python DateTime
Return type:: datetime.datetime

static uno_dt_to_dt(uno_dt)[source]

Converts a uno DateTime struct to a datetime instance.

Method is Lo Instance Safe for use with multiple documents.

Parameters:: uno_dt (UnoDateTime) – uno Datetime struct
Returns:: Python DateTime
Return type:: datetime.datetime

static uno_time_to_date_time(uno_time)[source]

Converts a uno Time struct to a datetime instance

Parameters:: uno_time (UnoTime) – uno Time struct
Returns:: Python DateTime
Return type:: datetime.datetime

static uno_time_to_time(uno_time)[source]

Converts a uno Time struct to a time instance

Parameters:: uno_time (UnoTime) – uno Time struct
Returns:: Python Time
Return type:: datetime.time

epoch

now = datetime.datetime(2024, 5, 18, 19, 18, 10)

now_time

today = datetime.date(2024, 5, 18)