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
Let's share thisShare on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin