The cast function to return the date added column

Assignment Help PL-SQL Programming

Reference no: EM13165623

Write a SELECT statement that returns these columns from the Products table:

The ListPrice column

A column that uses the CAST function to return the ListPrice column with 1 digit to the

right of the decimal point

A column that uses the CONVERT function to return the ListPrice column as an integer

A column that uses the CAST function to return the ListPrice column as an integer

2. Write a SELECT statement that returns these columns from the Products table:

The DateAdded column

A column that uses the CAST function to return the DateAdded column with its date only

(year, month, and day)

A column that uses the CAST function to return the DateAdded column with its full time

only (hour, minutes, seconds, and milliseconds)

A column that uses the CAST function to return the OrderDate column with just the

month and day

3. Write a SELECT statement that returns these columns from the Orders table:

A column that uses the CONVERT function to return the OrderDate column in this

format: MM/DD/YYYY. In other words, use two-digit months, days, and years and

separate each date component with slashes

A column that uses the CONVERT function to return the OrderDate column with the

date, and the hours and minutes on a 12-hour clock with an am/pm indicator

A column that uses the CONVERT function to return the OrderDate column with 2-digit

hours, minutes, and seconds on a 24-hour clock. Use leading zeros for all date/time

components.

Reference no: EM13165623

Questions Cloud

State an industrial chemist studying bleaching : An industrial chemist studying bleaching and sterilizing prepares a hypochlorite buffer using 0.150 M HClO and 0.150 M NaClO. (Ka for HClO = 2.9x10^-8.)

Explain the movement of gas particles : Question1. Describe the movement of gas particles. ; Question2. Compare the shape and volume of a solid and a gas.; Question3. Gases are easily compressed.

Which drags html list items to and from a javascript array : Write a program which drags html list items to and from a javascript array.

Describe strong weak and concentrated dilute : strong/weak and concentrated/dilute. Provide an appropriate example using each of these terms to describe a solution

The cast function to return the date added column : A column that uses the CAST function to return the DateAdded column with its full time only (hour, minutes, seconds, and milliseconds)

Write the decayreaction for this isotope : Write the decayreaction for this isotope and explain your prediction in terms of N/Zratio.

Case for global accounting standards : The case for global accounting standards by Professor Ann Tarca (UWA) and analyse what the key points are of the report. Then prepare a report either supporting or challenging the position of the author.

Calculate the theoretical yield of c2h5cl : Calculate the theoretical yield of C2H5Cl when 110 g of C2H6 reacts with 226 g of Cl2, assuming that C2H6 and Cl2 react only to form C2H5Cl and HCl.

Use tflon or ungreased stopcock rather than greased : why is preferable to use tflon or ungreased stopcock rather than greased stopcock in column chromatography experiment?

User Account

All Pages