PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

1 byte added , 25 December 2015

m

14,983

edits

Revision as of 19:22, 25 December 2015 (edit) Planetoid (talk \| contribs) (→‎specified time) ← Older edit		Revision as of 19:23, 25 December 2015 (edit) (undo) Planetoid (talk \| contribs) m (→‎specified time) Newer edit →
Line 40:		Line 40:


	convert month name to numeric date ex: May 1, 2015 -> ~~215~~-01-01		convert month name to numeric date ex: May 1, 2015 -> 2015-05-01
	* MySQL: [http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)] ex: {{kbd \| key=<nowiki>SELECT STR_TO_DATE('May 1, 2015','%M %d, %Y');</nowiki>}}<ref>[http://stackoverflow.com/questions/7027129/mysql-monthname-from-numbers MySQL MONTHNAME() from numbers - Stack Overflow]</ref>		* MySQL: [http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)] ex: {{kbd \| key=<nowiki>SELECT STR_TO_DATE('May 1, 2015','%M %d, %Y');</nowiki>}}<ref>[http://stackoverflow.com/questions/7027129/mysql-monthname-from-numbers MySQL MONTHNAME() from numbers - Stack Overflow]</ref>