You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
#74 is related issue but this is little more specific.
Add Function Column works well with numeric types as intended,
but with string type, text slice is not working.
I think python expression should support string slice, as python is famous for being convenient for text slicing.
(timestamp column in the screenshot above is string type. not datetime)
The text was updated successfully, but these errors were encountered:
For now, use sqlite instead of python.
sqlite support datetime functions. see https://www.sqlite.org/lang_datefunc.html
For your information, sqlite uses IS0-8601 date and time formats, that is,
A time string can be in any of the following formats:
YYYY-MM-DD
YYYY-MM-DD HH:MM
YYYY-MM-DD HH:MM:SS
YYYY-MM-DD HH:MM:SS.SSS
YYYY-MM-DDTHH:MM
YYYY-MM-DDTHH:MM:SS
YYYY-MM-DDTHH:MM:SS.SSS
HH:MM
HH:MM:SS
HH:MM:SS.SSS
now
DDDDDDDDDD
strftime function(format, timestring) can be used in this circumstance.
query executor based on sqlite will be developed. one can use not only built-in sql function, aggregate functions but also several udfs and udafs developed by us, or functions developed by herself.
#74 is related issue but this is little more specific.
Add Function Column works well with numeric types as intended,
but with string type, text slice is not working.
I think python expression should support string slice, as python is famous for being convenient for text slicing.
(timestamp column in the screenshot above is string type. not datetime)
The text was updated successfully, but these errors were encountered: