Cara memasukkan tanggal di mysql dalam format dd/mm/yyyy

Masalah ini menjelaskan format tanggal untuk memasukkan tanggal ke dalam database MySQL. MySQL mengambil dan menampilkan nilai DATETIME di 'YYYY-MM-DD HH. MM. format SS. Tanggal hanya dapat disimpan dalam format ini. Namun, ini dapat digunakan dengan fungsi format waktu apa saja untuk mengubahnya dan menampilkannya

Saat menulis kueri di MySQL menggunakan PHP, penerapannya akan diperiksa berdasarkan MySQL itu sendiri. Jadi gunakan format tanggal dan waktu default seperti yang disediakan oleh MySQL i. e. 'YYYY-MM-DD'

Contoh

DATE: YYYY-MM-DD Example: 2005-12-26 DATETIME: YYYY-MM-DD HH:MI:SS Example: 2005-12-26 23:50:30 TIMESTAMP: YYYY-MM-DD HH:MI:SS Example: 2005-12-26 23:50:30 YEAR: YYYY or YY

Permintaan MySQL untuk membuat Database

CREATE DATABASE Date_time_example; _

Contoh 1. Program PHP untuk Membuat database dan tabel

php

<?php

 

$servername CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 1CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 3 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 5CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 7 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 9CREATE DATABASE Date_time_example; 2

Table date_test created successfully1 CREATE DATABASE Date_time_example; 0Table date_test created successfully3CREATE DATABASE Date_time_example; 2

 

Table date_test created successfully6

Table date_test created successfully7 Table date_test created successfully8$servernameNew record created successfully0CREATE DATABASE Date_time_example; 3New record created successfully0CREATE DATABASE Date_time_example; 7New record created successfully0Table date_test created successfully1 New record created successfully6

 

New record created successfully8

New record created successfully9 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 0Table date_test created successfully7 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 2

________29______3SELECT * FROM date_test WHERE created_at = '2018-12-05'; 4SELECT * FROM date_test WHERE created_at = '2018-12-05'; 5SELECT * FROM date_test WHERE created_at = '2018-12-05'; 6 ________29______7

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

(!Important) Wrong Query It returns no rows0

(!Important) Wrong Query It returns no rows1 (!Important) Wrong Query It returns no rows2

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3(!Important) Wrong Query It returns no rows4

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3(!Important) Wrong Query It returns no rows6

(!Important) Wrong Query It returns no rows7

 

New record created successfully9 SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 0Table date_test created successfully7New record created successfully0(!Important) Wrong Query It returns no rows1SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 4

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 7CREATE DATABASE Date_time_example; 2

________29______8<?php0 <?php1

________29______3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 <?php4 <?php5Table date_test created successfully7New record created successfully6

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

 0

 1Table date_test created successfully7New record created successfully6

 _4

Keluaran. Table date_test created successfully

Contoh 2. Program PHP untuk memasukkan tanggal ke dalam tabel

php

<?php

 

$servername CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 1CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 3 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 5CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 7 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 9CREATE DATABASE Date_time_example; 2

Table date_test created successfully1 CREATE DATABASE Date_time_example; 0Table date_test created successfully3CREATE DATABASE Date_time_example; 2

 

Table date_test created successfully6

Table date_test created successfully7 Table date_test created successfully8$servernameNew record created successfully0CREATE DATABASE Date_time_example; 3New record created successfully0CREATE DATABASE Date_time_example; 7New record created successfully0Table date_test created successfully1 New record created successfully6

 

New record created successfully8

New record created successfully9 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 0Table date_test created successfully7 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 2

________29______3SELECT * FROM date_test WHERE created_at = '2018-12-05'; 4SELECT * FROM date_test WHERE created_at = '2018-12-05'; 5SELECT * FROM date_test WHERE created_at = '2018-12-05'; 6 ________29______7

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

CREATE DATABASE Date_time_example; _28

(!Important) Wrong Query It returns no rows1 CREATE DATABASE Date_time_example; 30

CREATE DATABASE Date_time_example; 31CREATE DATABASE Date_time_example; 32CREATE DATABASE Date_time_example; 33 CREATE DATABASE Date_time_example; 34

 

New record created successfully9 SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 0Table date_test created successfully7New record created successfully0(!Important) Wrong Query It returns no rows1SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 4

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 CREATE DATABASE Date_time_example; 44CREATE DATABASE Date_time_example; 2

________29______8<?php0 <?php1

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 CREATE DATABASE Date_time_example; 51 CREATE DATABASE Date_time_example; 52(!Important) Wrong Query It returns no rows1 CREATE DATABASE Date_time_example; 52CREATE DATABASE Date_time_example; 55 <?php5Table date_test created successfully7________20______6

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

 0

 1Table date_test created successfully7New record created successfully6

 _4

Keluaran. New record created successfully

Contoh 3. Contoh ini digunakan untuk menampilkan baris mana yang dibuat pada 05-12-2018. Gunakan kueri berikut untuk menampilkan hasil
Kolom create_at tidak hanya berisi tanggal tetapi juga waktu. Sehingga akan muncul pesan error

SELECT * FROM date_test WHERE created_at = '2018-12-05';

Keluaran

(!Important) Wrong Query It returns no rows

Kueri yang Benar. Untuk memperbaikinya, gunakan fungsi DATE sebagai berikut

SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05';

php

<?php

 

$servername CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 1CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 3 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 5CREATE DATABASE Date_time_example; 2

CREATE DATABASE Date_time_example; 7 CREATE DATABASE Date_time_example; 0CREATE DATABASE Date_time_example; 9CREATE DATABASE Date_time_example; 2

Table date_test created successfully1 CREATE DATABASE Date_time_example; 0Table date_test created successfully3CREATE DATABASE Date_time_example; 2

 

Table date_test created successfully6

Table date_test created successfully7 Table date_test created successfully8$servernameNew record created successfully0CREATE DATABASE Date_time_example; 3New record created successfully0CREATE DATABASE Date_time_example; 7New record created successfully0Table date_test created successfully1 New record created successfully6

 

New record created successfully8

New record created successfully9 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 0Table date_test created successfully7 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 2

________29______3SELECT * FROM date_test WHERE created_at = '2018-12-05'; 4SELECT * FROM date_test WHERE created_at = '2018-12-05'; 5SELECT * FROM date_test WHERE created_at = '2018-12-05'; 6 ________29______7

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

Table date_test created successfully_09

(!Important) Wrong Query It returns no rows1 Table date_test created successfully11

Table date_test created successfully12Table date_test created successfully13Table date_test created successfully14Table date_test created successfully15Table date_test created successfully16

 

Table date_test created successfully18 Table date_test created successfully19Table date_test created successfully7New record created successfully0________38______1 Table date_test created successfully23

 

New record created successfully9 SELECT * FROM date_test WHERE created_at = '2018-12-05'; 5Table date_test created successfully18SELECT * FROM date_test WHERE created_at = '2018-12-05'; 2

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 Table date_test created successfully18CREATE DATABASE Date_time_example; 2Table date_test created successfully33

Table date_test created successfully_34

________207______0 <?php1

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 3SELECT * FROM date_test WHERE DATE( created_at ) = '2018-12-05'; 6 CREATE DATABASE Date_time_example; 51 CREATE DATABASE Date_time_example; 52(!Important) Wrong Query It returns no rows1 CREATE DATABASE Date_time_example; 52CREATE DATABASE Date_time_example; 55 <?php5Table date_test created successfully7________20______6

SELECT * FROM date_test WHERE created_at = '2018-12-05'; 8

 

 0

 1Table date_test created successfully7New record created successfully6

 _4

Keluaran

Untuk mendapatkan tahun, kuartal, bulan, minggu, hari, jam, menit, dan detik dari nilai DATETIME, gunakan fungsi seperti yang ditunjukkan pada pernyataan berikut
JAM(@dt), MENIT(@dt), DETIK(@dt), HARI(@dt), MINGGU(@dt), BULAN(@dt), KUARTAL(@dt), TAHUN(@dt);

PHP adalah bahasa skrip sisi server yang dirancang khusus untuk pengembangan web. Anda dapat mempelajari PHP dari bawah ke atas dengan mengikuti Tutorial PHP dan Contoh PHP ini

Bagaimana cara memasukkan format tanggal di MySQL?

Bagaimana Anda memasukkan tanggal di YYYY

Bagaimana cara mengubah format tipe data tanggal di MySQL?