skip to main
|
skip to sidebar
Simple life, Complicated mind
Wednesday, August 27, 2014
How to convert date format in MySQL
SELECT DATE_FORMAT(STR_TO_DATE('08/07/2014', '%m/%d/%Y'), '%Y-%m-%d')
SELECT DATE_FORMAT(STR_TO_DATE('8/7/2014', '%c/%e/%Y'), '%Y-%m-%d')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Total Pageviews
Search This Blog
About Me
https://github.com/junxie6
https://stackoverflow.com/users/409319/jun-hsieh
https://blog.ijun.org/
Recommended Articles
CentOS and Red Hat 7: Install Linux, Apache MPM, MariaDB, PHP (LAMP) Stack
Install MySQL 5.7, Apache 2.4, PHP 7.1 on Ubuntu 16.04
Labels
Amazon Web Services
(9)
Android
(2)
AngularJS
(2)
Apache
(72)
Arduino
(1)
Assembly
(19)
Backup
(39)
Bash
(8)
Batch
(14)
Big Data
(1)
Book
(1)
Business Terminology
(9)
C
(58)
C# .NET
(71)
command
(71)
Computer Terminology
(27)
Data
(1)
Data mining
(1)
Debian
(1)
Debugging
(52)
Django
(7)
DNS
(5)
Docker
(12)
Drupal
(125)
Drupal 8
(12)
Elasticsearch
(1)
English Vocabulary
(56)
ERP
(3)
Excel
(4)
Exchange Server
(41)
FFmpeg
(4)
Financial Management
(1)
FreeBSD
(270)
Game
(1)
Git
(8)
golang
(54)
Golden Saying Quotation
(77)
Good Articles
(143)
Google Sheets
(1)
Hardware
(5)
Health
(8)
HTML/CSS
(46)
HTML5
(3)
IIS
(14)
ImageMagick
(3)
Internet of Things (IoT)
(3)
iPhone
(2)
Issue Tracker
(2)
IT Talk
(4)
Java
(1)
JavaScript
(79)
jQuery
(61)
jQWidgets
(2)
Linux
(111)
Load Balancing
(19)
Mac OS X
(15)
Magento
(70)
Magento 2
(13)
Mail
(17)
Math
(4)
Miscellaneous (Others)
(30)
Money
(11)
MongoDB
(2)
MySQL
(172)
Network
(13)
News
(4)
Nginx
(16)
Node.js
(3)
Performance
(31)
Perl
(12)
pfSense
(7)
PHP
(183)
PhpStorm
(3)
PHPUnit
(2)
Postfix
(3)
PostgreSQL
(2)
PowerShell
(5)
PrestaShop
(2)
Printer
(5)
Programming Talk
(152)
Prometheus
(1)
Proxy
(9)
Python
(19)
Raspberry PI
(4)
Redis
(3)
Redundancy
(8)
Regular Expression
(16)
Restaurant
(1)
Reverse Engineering
(1)
Revision Control
(32)
RouterOS
(1)
Ruby
(3)
Script
(8)
Security
(16)
Software Quality Assurance and Testing
(21)
SQL Injection
(11)
SQL Server
(77)
SSH
(5)
Storage
(3)
Symfony
(25)
tmp
(31)
ToDo
(181)
Tools
(156)
Two-factor Authentication
(3)
Ubuntu
(25)
Unicode
(32)
Unix-like Tips
(88)
VB .NET
(4)
VBScript
(66)
Video conferencing
(2)
vim
(101)
VirtualBox
(2)
Virtualization
(8)
VMware
(21)
VoIP
(1)
VPN
(14)
Vue
(3)
Web Development
(6)
Windows API
(1)
Windows MIS
(127)
Windows Mobile
(4)
WPF
(1)
X Window
(2)
Xen
(2)
XML
(6)
Zend Studio
(1)
Blog Archive
►
2019
(9)
►
June
(1)
►
April
(1)
►
March
(2)
►
February
(3)
►
January
(2)
►
2018
(49)
►
November
(2)
►
October
(4)
►
September
(13)
►
August
(3)
►
July
(2)
►
June
(1)
►
May
(6)
►
February
(8)
►
January
(10)
►
2017
(94)
►
December
(19)
►
November
(2)
►
October
(11)
►
September
(11)
►
July
(4)
►
June
(1)
►
May
(5)
►
April
(6)
►
March
(4)
►
February
(25)
►
January
(6)
►
2016
(196)
►
December
(10)
►
November
(11)
►
October
(17)
►
September
(5)
►
August
(3)
►
July
(9)
►
June
(15)
►
May
(14)
►
April
(35)
►
March
(49)
►
February
(10)
►
January
(18)
►
2015
(306)
►
December
(26)
►
November
(24)
►
October
(9)
►
September
(23)
►
August
(18)
►
July
(34)
►
June
(12)
►
May
(6)
►
April
(27)
►
March
(35)
►
February
(61)
►
January
(31)
▼
2014
(220)
►
December
(23)
►
November
(53)
►
October
(4)
►
September
(7)
▼
August
(17)
盤點 Design Patterns
MySQL trigger write data to file
How to convert date format in MySQL
1744 追蹤橘報: 切換至简体 程式設計師的時光傳話筒:過去的我,希望你能夠在工作前學會這 ...
7Zip does not terminate exit close after finished ...
C# start run external process program
rename move database on MySQL
Optimize nginx and PHP-FPM (max_children)
Window Sysinternals has announced a brand new tool...
《電學之父 - 法拉第的故事》讀書心得
《電學之父 - 法拉第的故事》讀後感
追求神乎其技的程式設計之道(番外篇)
追求神乎其技的程式設計之道(十)
向上管理:從定位你與主管之間的真正關係開始
find command two multiple file extensions with reg...
rsync - synchronizing two file trees strcuture
How can I get a list of shared directories on loca...
►
July
(35)
►
June
(18)
►
May
(2)
►
April
(20)
►
March
(10)
►
February
(20)
►
January
(11)
►
2013
(163)
►
December
(6)
►
November
(12)
►
October
(12)
►
September
(27)
►
August
(18)
►
July
(15)
►
June
(18)
►
May
(29)
►
April
(19)
►
March
(1)
►
January
(6)
►
2012
(131)
►
December
(22)
►
November
(11)
►
October
(6)
►
September
(2)
►
August
(1)
►
July
(5)
►
June
(13)
►
May
(16)
►
April
(8)
►
March
(7)
►
February
(9)
►
January
(31)
►
2011
(236)
►
December
(51)
►
November
(38)
►
October
(27)
►
September
(34)
►
August
(5)
►
July
(8)
►
June
(6)
►
May
(14)
►
April
(4)
►
March
(19)
►
February
(6)
►
January
(24)
►
2010
(259)
►
December
(56)
►
November
(43)
►
October
(6)
►
September
(7)
►
August
(18)
►
July
(39)
►
June
(12)
►
May
(25)
►
April
(12)
►
March
(14)
►
February
(9)
►
January
(18)
►
2009
(742)
►
December
(58)
►
November
(143)
►
October
(55)
►
September
(48)
►
August
(35)
►
July
(31)
►
June
(40)
►
May
(25)
►
April
(95)
►
March
(99)
►
February
(42)
►
January
(71)
►
2008
(273)
►
December
(70)
►
November
(71)
►
October
(68)
►
September
(54)
►
August
(2)
►
July
(7)
►
June
(1)
Popular Posts
Magento Get Add to Cart URL of any Product
搬家愈多次,物質慾愈少?
寫程式是一種超能力
800a0004 Invalid algorithm specified / Invalid flags specified Persits ASP encryption
Volume Shadow Copy Failed to create the storage area association
NginX with FastCGI and C
Squid transparent SSL proxy on pfSense
Passing an argument to a Block View in Drupal 6
Realtime File System Replication On FreeBSD
simply accounting - How to connect to MySQL Server
Recommend Sites
fcamel 技術隨手記
fcamel's blog
FourDollars Blog
Fred's Blog
Gea-Suan Lin's BLOG
SCRATCHING MY NEEDS
Think Exist
Thinker
一又@CROSS [ SSORC.tw ]
小惡魔 AppleBOY
Joey
No comments:
Post a Comment