[
https://issues.apache.org/jira/browse/CASSANDRA-18879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arun Ganesh updated CASSANDRA-18879:
------------------------------------
Test and Documentation Plan:
Tested it manually.
My timezone is US/Eastern. You can see the tracing output showing the time
({{{}2024-01-16 16:18:43.599000-05:00{}}}) in my timezone and the table
containing the time in UTC ({{{}2024-01-16 21:18:43.599000+0000{}}}).
(See attached [log
file|https://issues.apache.org/jira/secure/attachment/13066068/cassandra-cqlsh-stdout])
was:
Tested it manually.
My timezone is US/Eastern. You can see the tracing output showing the time
({{{}2024-01-16 16:18:43.599000-05:00{}}}) in my timezone and the table
containing the time in UTC ({{{}2024-01-16 21:18:43.599000+0000{}}}).
(See attached log file)
> Modernize CQLSH datetime conversions
> ------------------------------------
>
> Key: CASSANDRA-18879
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18879
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL/Interpreter
> Reporter: Brad Schoening
> Assignee: Arun Ganesh
> Priority: Low
> Attachments: cassandra-cqlsh-stdout
>
> Time Spent: 2h
> Remaining Estimate: 0h
>
> Python 3.x introduced many updates to datetime conversion which allows
> simplified conversions.
> 1. For example, tracing.py defines a function datetime_from_utc_to_local()
> but datetime now has a native function astimezone() which will convert UTC to
> local time.
> Review the following users of datetime which apply conversions:
> * cqlshmain.py
> * formatting.py
> * tracing.py
> Example:
> {code:java}
> >>> from dateutil import tz
> >>> import datetime
> >>> a = datetime.datetime.now().astimezone(tz.tzutc())
> >>> a
> datetime.datetime(2023, 9, 25, 11, 22, 36, 251705, tzinfo=tzutc())
> >>> b = a.astimezone()
> >>> b
> datetime.datetime(2023, 9, 25, 14, 22, 36, 251705,
> tzinfo=datetime.timezone(datetime.timedelta(seconds=10800), 'EST')) {code}
> See [[PEP 495|http://example.com]]]
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
