linuxMaestro
Instructor
How can I convert date stamps such as:
1049860800
1112331600
1049860800
1113451200
To a readable format such as:
01-01-2005
1049860800
1112331600
1049860800
1113451200
To a readable format such as:
01-01-2005
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I convert date stamps into a readable format?
- Thread starter linuxMaestro
- Start date
- Status
sleipnir214
Programmer
close 
date_format(from_unixtime(1049860800),"%Y-%m-%d")
rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)
date_format(from_unixtime(1049860800),"%Y-%m-%d")
rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)
- Status
Similar threads
- Locked
- Question
