Timestamp showing differently on the local system and on the live system.

On the local it is showing as 2007-06-06 13:14:56 but on the live
it is showing as 20070606131456.

Gives no results when i want to select a record where timestamp is like %06%.

Is there any solution to this problem.

All i need is to get the same timestamp value that is displaying on local system but on live system as it is.

plz help me out here.

thanks in advance

NareshPHP,
This is how I understand your problem.
The 2007-06-06 13:14:56 is a datetime datatype with MySQL
and the 20070606131456 is a MySQL UNIX timestamp and PHP UNIX timestamp as well.
If you want to filter this in your sql query
for the day 6 of the month or 6th month/ June.
For example:
SELECT * FROM TABLENAME
WHER DATE_FORMAT(FIELDNAME, %m) = '06';

or
SELECT * FROM TABLENAME
WHER DATE_FORMAT(FIELDNAME, %d) = '06';




Hope this helps,
John