mysql format date
DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats
4.43
7
use \Datetime;
$now = new DateTime();
echo $now->format('Y-m-d H:i:s'); // MySQL datetime format
echo $now->getTimestamp(); // Unix Timestamp -- Since PHP 5.3
Thank you!
7
0
0
0
-- Converts 'dd.mm.yyyy' to date (my_date_col is VARCHAR)
SELECT STR_TO_DATE(my_date_col,'%d.%m.%Y') AS my_strdate FROM my_table;
-- Converts 'dd.mm.yyyy' to 'YYYY-MM-DD'
SELECT DATE_FORMAT(STR_TO_DATE(my_date_col,'%d.%m.%Y'), '%Y-%m-%d') AS my_strdate
FROM my_table;
Thank you!
0
0
4.33
3
DATE : stocke une date au format AAAA-MM-JJ (Année-Mois-Jour) ;
TIME : stocke un moment au format HH:MM:SS (Heures:Minutes:Secondes) ;
DATETIME : stocke la combinaison d'une date et d'un moment de la journée au format AAAA-MM-JJ HH:MM:SS. Ce type de champ est donc plus précis ;
TIMESTAMP : stocke le nombre de secondes passées depuis le 1er janvier 1970 à 00 h 00 min 00 s ;
YEAR : stocke une année, soit au format AA, soit au format AAAA.
Thank you!
3
0
3.4
10
DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p')
#Format is 'June 10, 2014 @ 06:52 PM'
Thank you!
10
0
3.75
7
-- use DATE_FORMAT with %H %i
-- SELECT DATE_FORMAT(MemberBookFacility.time, '%H:%i')
"45": "09:00",
"24": "10:00",
"42": "11:00",
"48": "12:00",
-- ONcakephp must use below format
$this->virtualFields['time'] = "DATE_FORMAT(MemberBookFacility.time, '%H:%i')"; // using this for use concat
return $this->find('list', array(
'conditions' => $conditions,
'fields' => array(
'MemberBookFacility.id',
'time',
),
'order' => array(
'MemberBookFacility.time ASC',
),
));
Thank you!
7
0
Are there any code examples left?
New code examples in category SQL
-
SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
-
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
-
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
-
SQL 2022-03-27 19:20:41 sql is not null
-
SQL 2022-03-27 19:20:39 sql group by error
-
SQL 2022-03-27 18:35:10 replace null with 0 in sql
-
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
-
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
-
SQL 2022-03-27 16:45:07 kill a pid redshift
-
SQL 2022-03-27 16:00:09 joins in sql server