HomeworkLib
Question

Query question? table name:employee column name:birth_date Birth date format is 14-OCT-61 day-month-year How do I get...

Query question?

table name:employee

column name:birth_date

Birth date format is 14-OCT-61 day-month-year

How do I get that date to display in a column as 10/14/1961? in SQL

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

You can do so by using the DATE_FORMAT function provided by MySQL.

SELECT

    DATE_FORMAT(birth_date, '%m/%d/%Y') birth_date,

FROM

    Employee;

0 0
Add a comment
Know the answer?
Add Answer to:
Query question? table name:employee column name:birth_date Birth date format is 14-OCT-61 day-month-year How do I get...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • CREATE TABLE offence ( off_datetime DATE NOT NULL) I wanna insert the date in this format...

    CREATE TABLE offence ( off_datetime DATE NOT NULL) I wanna insert the date in this format without == To_DATE('10-aug-2019 08:04 am', 'DD-MON-YYYY ', ' HH:MI'), I get an error how can I fix this . I need to use Date format in the table creation

  • In SQL, how do I put one column from one table right next to another column...

    In SQL, how do I put one column from one table right next to another column from a different table?

  • this is sql developer question I just need the format of how to answer question! Create...

    this is sql developer question I just need the format of how to answer question! Create sequences (2) that can be used to number the member ID and group ID values starting with 3 (since you already have 1 and 2). Write an INSERT statement that adds another row to the Groups table, make up a group name. Use the NEXTVAL pseudo column to get the value for the next group ID from the sequence that you created in #5....

  • I want write a MySQL query to get the number of customers who have made at...

    I want write a MySQL query to get the number of customers who have made at least one purchase in each group (gender, education), I know how to do with two seperate query. but is that possible to get one query with the column like: gender | counts | education | counts The first 5 rows of each table looks like this: customers customer_id | first_name | last_name | state | birthdate | education | gender | date_account_opened 50 |...

  • Using c++.Complete the implementation of the class date that represents dates written in the form day/month/year....

    Using c++.Complete the implementation of the class date that represents dates written in the form day/month/year. Do not modify the main program. You must write the prototypes and the definitions of the methods of the class. Declaration of Class Date /File: date.h A class representing dates in the form: day, month and year dat e s are written to a stream in the form day/mon th / year day number () returns the number of days since 1/1 of the...

  • (Using Oracle SQL) How do I find the primary key of this table? And then how...

    (Using Oracle SQL) How do I find the primary key of this table? And then how do I consequently drop the primary key from the table? Edit: I was already give this code and it did not work select constraint_name,constraint_type from user_constraint where table_name='CUSTOMER'; Q7 (10 Points) Use ONE SQL statement to find out the name of the primary key constraint defined on Customer table. (Your SQL should return something like SYS_C0021715, numbers on your account may differ.) Then use...

  • In C programming. How do you build a calendar? I can't get the days to work...

    In C programming. How do you build a calendar? I can't get the days to work right. This is what I have so far #include <stdio.h> #include <string.h> #include <stdlib.h> int dow(int year, int month, int day) {     static int t[] = {0, 3, 2, 5, 0, 3, 5, 1, 4, 6, 2, 4};     year -= month < 3;     return (year + year/4 - year/100 + year/400 + t[month-1] + day) % 7; } int main() {...

  • Can someone please help me with this problem, I am new in this and I got no idea how to make it ?

    Must contain several methods to provide reading functions,performing calculations and posting the results.Main Main method for executing execution Method for reading data from the keyboard Method for performing calculations according to the problem request Method for posting resultsThe main method must contain at least:A menu for selecting the function (Reading data, Performing calculations, Posting ioutput, Exit the program) using the switch / case instruction.The menu must be included within a do / while cycle in order for the e functions...

  • Can you please explain how you get to the answer? I have been trying to figure...

    Can you please explain how you get to the answer? I have been trying to figure this out all day. Thanks! The periodic inventory records of Halton Prosthetics indicate the following for the month of October: EE (Click the icon to view the inventory records.) At October 31, Halton counts nine units of inventory on hand Compute ending merchandise inventory and cost of goods sold for Halton using the FIFO inventory costing method FIFO Cost Data Table Ending Merchandise Inventory...

  • Hi good day i need homework help fast please d32 1./What is the maximum length that...

    Hi good day i need homework help fast please d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT