Replies: 1 comment
|
Realized this is covered by DatePart: https://datalust.co/docs/working-with-dates-and-times#the-datepartdatetime-part-offset-function I was only looking at the CheatSheet which doesn't mention it. |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
I would like to request that SEQ provides a new Date and Time function, that can take a timestamp and return if it's Monday..Sunday. I propose its called
DayName, similar to MySQL function name.Usecase: I would like to create a query that matches a message, but only on Saturday & Sunday.
I think it should support Timestamps and
iso 8601string as parameters.Output is the literal string
Monday,Tuesdayetc.Stretch goals:
Implement the other
DayOffunctions to match MySql:Reference: https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html#:~:text=Synonym%20for%20DAYOFMONTH()-,DAYNAME(),-Return%20the%20name
All reactions