MYSQL Unixtime to US Date Format

MySQL Unixtime to US Date Format
You can format your Unix formatted date straight from the MySQL database and here is the query that will allow you to do so:

select FROM_UNIXTIME(U.signup_date, '%m/%d/%Y %h:%i:%s') as time  from YCSOFTWARE_TBL