Time in filter box is showing as unix timestamp

[rajeshchy]

I am trying to use filter box and trying to filter data based on date. when i create filter based on date then date is being shown in epoch time.

Expected results

Date should show in yyyy-mm-dd format

Actual results

it shows in epoch time like: 1568505600000

Screenshots

https://drive.google.com/file/d/1gTnKG8QkMWkzXoiRF-5fXiwpMo_f5LqC/view?usp=sharing

How to reproduce the bug

1. Create a table in postgres with DATE column
2. now create table in superset
3. Change the Datetime Format in column of table to %Y-%m-%d
4. try to create the filter box using that column

Environment

Running superset with docker.

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.84. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[rajeshchy]

Screenshot:

[williamdrake]

I'm getting this as well. Not sure of a workaround since we can't filter by custom Metrics.

[umesh11111]

change the core.py file under utils folder and change the json_int_dttm_ser function

def json_int_dttm_ser(obj):
"""json serializer that deals with dates"""
val = base_json_conv(obj)
if val is not None:
return val
if isinstance(obj, (datetime, pd.Timestamp)):
# obj = datetime_to_epoch(obj)
obj = obj.strftime("%m/%d/%Y")
elif isinstance(obj, date):

    obj = (obj - EPOCH.date()).total_seconds() * 1000
    obj = obj.strftime("%m/%d/%Y")
else:
    raise TypeError("Unserializable object {} of type {}".format(obj, type(obj)))
return obj

this worked for me ..

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[junlincc]

problem resolved. #10268

[snehlata08]

change the core.py file under utils folder and change the json_int_dttm_ser function

def json_int_dttm_ser(obj): """json serializer that deals with dates""" val = base_json_conv(obj) if val is not None: return val if isinstance(obj, (datetime, pd.Timestamp)): # obj = datetime_to_epoch(obj) obj = obj.strftime("%m/%d/%Y") elif isinstance(obj, date):

    obj = (obj - EPOCH.date()).total_seconds() * 1000
    obj = obj.strftime("%m/%d/%Y")
else:
    raise TypeError("Unserializable object {} of type {}".format(obj, type(obj)))
return obj

this worked for me ..

This didn't work for me. Can you please show the full code. Is there some mistake that I might have done.