I have a table with a bunch of columns with random stuff in them.
One of the columns is a date + time column that has this kind of format:
- 11-01-24 00:00:00.000000000
- 11-01-27 02:00:00.000000000
Now, as you can see, the first few numbers are the year, month, and date, the next few numbers are the hour, minutes, and second, but the last part, well, I'm honestly not too sure; I took over this database a while ago, so that format is a bit alien to me (if someone can clarify this, it'd be great; not important, though).
Given this format, is it possible to get the day of the week?
I know for some scripting and programming code, you can usually find this kind of information by using some sort of date function, but I can't seem to find one for Oracle SQL.
It would be something like:
SELECT *
FROM <table>
WHERE some_function(date_period) = 'SAT'
Thanks a lot for any feedback!