Skip to main content

MySQL practical Tutorials part 7- sql Date Float, double , Date datatype all queries

Mysql Date Float, double , Date datatype all queries

=======================================================================================================================

FLOAT and DOUBLE

CREATE TABLE thingies (price FLOAT);

 

INSERT INTO thingies(price) VALUES (88.45);

 

SELECT * FROM thingies;

 

INSERT INTO thingies(price) VALUES (8877.45);

 

SELECT * FROM thingies;

 

INSERT INTO thingies(price) VALUES (8877665544.45);

 

SELECT * FROM thingies;


=======================================================================================================================

Creating Our DATE data

CREATE TABLE people (name VARCHAR(100), birthdate DATE, birthtime TIME, birthdt DATETIME);

 

INSERT INTO people (name, birthdate, birthtime, birthdt)

VALUES('Padma', '1983-11-11', '10:07:35', '1983-11-11 10:07:35');

 

INSERT INTO people (name, birthdate, birthtime, birthdt)

VALUES('Larry', '1943-12-25', '04:10:42', '1943-12-25 04:10:42');

 

SELECT * FROM people;

=======================================================================================================================

Formatting Dates

SELECT name, birthdate FROM people;

 

SELECT name, DAY(birthdate) FROM people;

 

SELECT name, birthdate, DAY(birthdate) FROM people;

 

SELECT name, birthdate, DAYNAME(birthdate) FROM people;

 

SELECT name, birthdate, DAYOFWEEK(birthdate) FROM people;

 

SELECT name, birthdate, DAYOFYEAR(birthdate) FROM people;

 

SELECT name, birthtime, DAYOFYEAR(birthtime) FROM people;

 

SELECT name, birthdt, DAYOFYEAR(birthdt) FROM people;

 

SELECT name, birthdt, MONTH(birthdt) FROM people;

 

SELECT name, birthdt, MONTHNAME(birthdt) FROM people;

 

SELECT name, birthtime, HOUR(birthtime) FROM people;

 

SELECT name, birthtime, MINUTE(birthtime) FROM people;

 

SELECT CONCAT(MONTHNAME(birthdate), ' ', DAY(birthdate), ' ', YEAR(birthdate)) FROM people;

 

SELECT DATE_FORMAT(birthdt, 'Was born on a %W') FROM people;

 

SELECT DATE_FORMAT(birthdt, '%m/%d/%Y') FROM people;

 

SELECT DATE_FORMAT(birthdt, '%m/%d/%Y at %h:%i') FROM people;

Labels:
Location: Ahmednagar, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...
Post a Comment
Read more

MySQL practical Tutorials part 9- SQL not operator, SQL Not Like, SQL greater than, SQL less than greater than operator

 ========================================================================= Not Equal SELECT title FROM books WHERE released_year = 2017;   SELECT title FROM books WHERE released_year != 2017;   SELECT title, author_lname FROM books;   SELECT title, author_lname FROM books WHERE author_lname = 'Harris';   SELECT title, author_lname FROM books WHERE author_lname != 'Harris'; ========================================================================= Not Like SELECT title FROM books WHERE title LIKE 'W';   SELECT title FROM books WHERE title LIKE 'W%';   SELECT title FROM books WHERE title LIKE '%W%';   SELECT title FROM books WHERE title LIKE 'W%';   SELECT title FROM books WHERE title NOT LIKE 'W%'; ========================================================================= Greater Than SELECT title, released_year FROM books ORDER BY released_year;   SELECT title, released_year FROM books  WHERE released_year > 2000 ORDER BY release...
Post a Comment
Read more

MULTIPLEXER , Design & Implement the given 4 variable function using IC74LS153. Verify its Truth-Table

TITLE: MULTIPLEXER   AIM: Design & Implement the given 4 variable function using IC74LS153. Verify its Truth-Table.   LEARNING OBJECTIVE: ·        To learn about IC 74153 and its internal structure. ·        To realize 8:1 MUX and 16:1 MUX using IC 74153.   COMPONENTS REQUIRED: IC 74153, IC 7404, IC 7432, CDS, wires, Power supply. IC PINOUT:            1)     IC 74153 2)      IC 7404:                                              3) IC 7432 THEORY:   ·        Multiplexer is a combinational circuit that is one of the most widely used in digital design. ·        The multiplexer is a data selector which gates one out of several inputs to a sin...
Post a Comment
Read more