Get day of week for date column

[simeon.petkov]

When generating timestamps I need to have the day of the week (e.g. Saturday, Sunday, …) as a value. I can’t find a function for this.

Something like: weekday(my_date)

Any ideas?

[mp_np]

@simeon.petkov use the strftime function:
testdate.strftime("%A") where ‘testdate’ is the name of your date column.

See https://apidock.com/ruby/DateTime/strftime for more details of the options for this function

See https://www.mockaroo.com/5cdd1f60 for an example