PHP and MySQL syntax: Difference between revisions

Jump to navigation Jump to search
m
Line 17: Line 17:


  SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' );
  SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' );
off topic
* DOS: {{kbd | key=date/t}}
<pre>output:
OS in English: Thu 05/03/2012
OS in Chinese: 2012/05/03 星期四
</pre>


=== specified time ===
=== specified time ===

Navigation menu