I am given a MySQL 12 digit TimeStamp (253402214400) to format it in
mm/dd/yyyy
SELECT time_stamp;
253402214400
SELECT DATE_FORMAT(time_stamp,'%m/%d/%Y');
NULL
SELECT FROM_UNIXTIME(time_stamp);
NULL
SELECT UNIX_TIMESTAMP(time_stamp);
0
Timestamp
mm/dd/yyyy
Thanks
I am sorry everybody, I think the time was givin in milliseconds
, so by some research I could reach here http://stackoverflow.com/a/9483289/750302 and resolved it with DATE_FORMAT(FROM_UNIXTIME(time_stamp/1000), '%m/%d/%Y');
SQLFIDDLE! ...
Thank You Everyone for your Support!