can anybody tell me what format of date 1311048886 is? how we insert and select in database.

Member Avatar for diafol

Unix timestamp. Youcanuse php: time() for current timestamp

Strtotime() another useful one

Mysql:

UNIX_TIMESTAMP()

As ardav says it is a Unix timestamp and if you want to change it into a date format:

$date = date('Y-m-d', time());
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.