Posts Tagged ‘Date and Time Types’
Date format (날짜형식)
Posted by: spaceufo on: September 16, 2007
- In: php
- Leave a Comment
$today = date(”Y-m-d H:i:s”, time());
2007-01-01 17:16:17
$today = date(”F j, Y, g:i a”, time());
March 10, 2001, 5:16 pm
$today = date(”m.d.y”, time());
03.10.01
$today = date(”j, n, Y”, time());
10, 3, 2001
$today = date(”Ymd”, time());
20010310
$today = date(’h-i-s, j-m-y, it is w Day z ‘, time());
05-16-17, 10-03-01, 1631 1618 6 Fripm01
$today = date(’\i\t \i\s \t\h\e jS \d\a\y.’, time());
It is the 10th [...]
Mysql 4.11 Date and Time Functions
Posted by: spaceufo on: July 22, 2007
- In: MySQL
- Leave a Comment
*Reference :
http://www.mysql.com/search/?q=Date_and_time
4.11 Date and Time Functions
See section 7.3.3 Date and Time Types for a description of the range of values each type has and the valid formats in which date and time values may be specified.
Here is an example that uses date functions. The query below selects all records with a date_col value [...]
Search
Social code
