Recent Posts

SQL: Day Of Week By Name For A Date

less than 1 minute read

By using the to_char() function with a date or timestamp, we can determine the day of the week by name (e.g. Monday). For instance, to determine what day tod...

SQL: Count Records By Type

less than 1 minute read

If you have a table with some sort of type column on it, you can come up with a count of the records in that table by type. You just need to take advantage o...