Question

Explain date time functions and string functions.in my sql

  1. Explain date time functions and string functions.in my sql
Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

1. Date time functions in MySQL: They are used for a description of the range of values each date and time type has and the valid formats in which values may be specified. Few syntaxes are:

(a) ADDDATE() - adds date

(b) ADDTIME() - adds time

(c) CURDATE() - returns current date

(d) CURTIME() - returns current time

(e) DATE() - Extracts the date part of a date or datetime expression

(f) LAST_DAY() - Returns the last day of the month for the argument

2. String functions in MySQL:

(a) CHAR_LENGTH() - Returns the length of a string

(b) ASCII() - Returns the ASCII value for the specific character

(c) CONCAT() - Adds two or more expressions together

(d) LENGTH() - Returns the length of a string

(e) REVERSE() - Reverses a string and returns the result

(f) TRIM() - Removes leading and trailing spaces from a string

0 0
Know the answer?
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
Similar Questions
Explain why an organization might want to consider restricting access to the following SQL functions: COUNT,...
Explain why an organization might want to consider restricting access to the following SQL functions: COUNT, MIN, MAX, AVG, SUM.
Create a user-defined function in SQL to return a valid query author and date. This will...
Create a user-defined function in SQL to return a valid query author and date. This will be used for all views later on in future queries.
ON SQL Explain Normalization and Denormalization of data, What is ACID in SQL? Please explain in...
ON SQL Explain Normalization and Denormalization of data, What is ACID in SQL? Please explain in your own word as much as possible, List the steps in creating a View, List the steps in modifying a View, List the steps in creating a table, List the steps in modifying a table, What are the different Joins? please give examples, Create a database and populate the database with data of your choice, List and explain the different data types used in...
Python. create a function that takes a string as a parameter and prints out the following...
Python. create a function that takes a string as a parameter and prints out the following details as the example output below. If the string is "Hello, my name is Starling, Clarice. My, my, my, nice to meet you." The output would be: Unique words: 10 Number of commas: 5 Number of periods: 2 Number of sentences: 2 (HINT: Use the following string methods: split, lower, count, replace, format, and use the following functions: set, len. You may need to...
PYTHON Use Tkinter to display a My sql table and create a delete button that allows...
PYTHON Use Tkinter to display a My sql table and create a delete button that allows the user to delete entries with the vin field only ONLY error is displayed is the vin is not matched other wise Update tkinter if delete is successfuland dispaly updated table. Use the following database db = mc.connect( host="34.121.209.242", user="root", passwd="1234qwer", database="cars" )
Python: Write a RegEx that can check if a string is a specific date format; For...
Python: Write a RegEx that can check if a string is a specific date format; For example dateString = '11-09-2016'
Python: Write a RegEx that can check if a string is in a specific date format;...
Python: Write a RegEx that can check if a string is in a specific date format; For example dateString = '15 November 2009'
creat a c++ program that has 3 functions main will ask user to input a string...
creat a c++ program that has 3 functions main will ask user to input a string isvowel will loop the string and return true if there is a vowel printvowle will print all the vowels found
Can you explain the internal storage for string, in particular string literals, instances of string, and...
Can you explain the internal storage for string, in particular string literals, instances of string, and characters. Also, if two string variables have the same data, is the memory reference the same? String a = "test"; String b = "test"; will a and b both have the same memory address?
in java need uml diagram import java.util.ArrayList; import java.util.*; public class TodoList { String date=""; String...
in java need uml diagram import java.util.ArrayList; import java.util.*; public class TodoList { String date=""; String work=""; boolean completed=false; boolean important=false; public TodoList(String a,String b,boolean c,boolean d){ this.date=a; this.work=b; this.completed=c; this.important=d; } public boolean isCompleted(){ return this.completed; } public boolean isImportant(){ return this.important; } public String getDate(){ return this.date; } public String getTask(){ return this.work; } } class Main{ public static void main(String[] args) { ArrayList<TodoList> t1=new ArrayList<TodoList>(); TodoList t2=null; Scanner s=new Scanner(System.in); int a; String b="",c=""; boolean d,e; char...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT