Hi Guys , here are some more mysql commands which is useful in day 2 day work.
Method for converting current time stamp to date:
--------------------------------------------------------------
select from_unixtime(left(1201159475416, 10));
this method is used to convert the timestamp to the date time format in mysql ,left() method will return 10 char from the specified string if we store time stamp value in millisecond.
Read more »
Method for converting current time stamp to date:
--------------------------------------------------------------
select from_unixtime(left(1201159475416, 10));
this method is used to convert the timestamp to the date time format in mysql ,left() method will return 10 char from the specified string if we store time stamp value in millisecond.
