Write a query to return the date and day of the week of the first day...

Write a query to return the date and day of the week of the first day of the month two years from today.

If today is 10/16/20, then the expect output is 10/01/2022 and the day of the week is thursday.

I am using postgresql.

Expert Solution

first of all 10/01/2022 ---> oct /01/2022 is saturday. not thursday.

try the below query

----------------------------------------------

with daynumber as (select date_trunc('month', current_date + interval '2 years')as date,extract(isodow from date_trunc('month', current_date + interval '2 years')) -  0 daynumber ),
week as(select CASE 
         WHEN daynumber.daynumber =1 THEN 'Monday'
         WHEN daynumber.daynumber=2 THEN 'Tuesday'
         WHEN daynumber.daynumber=3 THEN 'Wednesday'
         WHEN daynumber.daynumber=4 THEN 'Thursday'
         WHEN daynumber.daynumber=5 THEN 'Friday'
         WHEN daynumber.daynumber=6 THEN 'Saturday'
         WHEN daynumber.daynumber=7 THEN 'Sunday'
     ELSE 'other'
   END from daynumber ) 
 select *from daynumber,week;

-----------------------------------

output

venereology answered 7 months ago

Write an SQL query that will output the employee id, first name and hire date from...

Write an SQL query that will output the employee id, first name and hire date from the employee table. Pick only those employees whose employee ID is specified in the employee table (no nulls). If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should be like - ' ABC (Employee ID - 777) was hired on 1, January of 2016'. Note - The date should not have preceding zeros.

Day of week Write a program that asks the user for a date (year, then month,...

Day of week Write a program that asks the user for a date (year, then month, then day, each entered as a number on a separate line), then calculates the day of the week that date falls on (according to the Gregorian calendar) and displays the day name. You may not use any date functions built into Python or its standard library, or any other functions that do this work for you. Hint: Reverend Zeller may be useful, but his...

What day of the week is a given date? i.e. On what day of the week...

What day of the week is a given date? i.e. On what day of the week was 5 August 1967? if it is given that 1 January 1900 was a tuesday Write a function is leap() which takes 1 input argument, an integer representing a year, and returns True if the year was a leap year, and False if it was not. .Then, write a function days_since() which takes 3 input integers day, month, year, representing a date (after 1st...

1. Write a query to: a. select data from INVOICES table as follows: Invoice date in...

1. Write a query to: a. select data from INVOICES table as follows: Invoice date in MM/DD/YYYY format Invoice Date in DD-Mon-YYYY format Invoice Total rounded to the nearest dollar Note: you can alias columns as you sit fit b. select data from VENDORS table as follows: Vendor Name Concatenate Vendor Name with the string ‘s Address Concatenate Vendor City, Vendor State and Vendor Zip Code (alias this) Your output should look like this (this is just an example of...

USE PYTHON to find out What day of the week is a given date? i.e. On...

USE PYTHON to find out What day of the week is a given date? i.e. On what day of the week was 5 August 1967? if it is given that 1 January 1900 was a tuesday Write a function is_leap() which takes 1 input argument, an integer representing a year, and returns True if the year was a leap year, and False if it was not. .Then, write a function days_since() which takes 3 input integers day, month, year, representing...

Complete the code so that it can convert the date to day of week using python,...

Complete the code so that it can convert the date to day of week using python, the code should pass the doctest def convert_datetime_to_dayofweek(datetime_string): """ This function takes date in the format MON DAY YEAR HH:MM(PM/AM) and returns the day of the week Assume input string is UTC >>> convert_datetime_to_dayofweek('Jun 1 2005 1:33PM') 'Wednesday' >>> convert_datetime_to_dayofweek('Oct 25 2012 2:17AM') 'Thursday' """ # code goes here

Write a c++ program that asks the user for a date (Month and Day only) and...

Write a c++ program that asks the user for a date (Month and Day only) and displays the season in this day.The program asks then the user if he needs to enter another date, if he answers with ’Y’ or ’y’, the programwill take another date from the user and displays the season in this day.The program will keep repeating this until the user enters a character different than ’Y’ and ’y’.•Fall starts in September 21st•Winter starts in December 21st•Spring...

1. How do I write a query that displays the name (concatenate the first name, middle...

1. How do I write a query that displays the name (concatenate the first name, middle initial, and last name), date of birth, and age for all students? Show the age with no decimal places, and only include those students who are 21 or older. Order by age, as shown below: (Hint: Use the TRUNC function. The ages may be different, depending on the date that the query is run.) SELECT S_FIRST || ' ' || S_MI || ' '...

Problem 44 Write a query to display the employee number, last name, first name, and sum...

Problem 44 Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by first name (Partial results shown in Figure P7.44).

Date - month: int - day: int - year: int +Date() +Date(month: int, day: int, year:...

Date - month: int - day: int - year: int +Date() +Date(month: int, day: int, year: int) +setDate(month: int, day: int, year: int): void -setDay(day: int): void -setMonth(month: int): void -setYear(year: int): void +getMonth():int +getDay():int +getYear():int +isLeapYear(): boolean +determineSeason(): string +printDate():void Create the class Constructor with no arguments sets the date to be January 1, 1900 Constructor with arguments CALLS THE SET FUNCTIONS to set the Month, then set the Year, and then set the Day - IN THAT ORDER...

Question