hey i've been reading up and looks like elasticsearch/logstash will store dates as UTC by default. makes sense
But here's the thing I'm trying to solve: I'm trying to do some analytics for an email marketing newsletter. It gets sent at say Monday 8pm PST. which is Tuesday 3AM UTC the next day. So the day of week is different. Which messes up a query for events only on a Monday.
Anyone got any ideas? Maybe I should index a separate field "weekday" or maybe store a PST datetime or something