clarkmurray
IS-IT--Management
My hosting company has a utility which allows me to dump the tables of a MySQL database in csv format for Excel. However, I can't figure out how to translate the numbers in date/time fields. Can anyone help?
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL Date/Time Format?
- Thread starter clarkmurray
- Start date
- Status
Date fields are yearmonth day in a string like 20050530.
Time should be hour:minute:second like 084654. The hour I believe is 24h time.
mysql TIMESTAMP (not a unix timestamp!) are these two concatenated together.
20050530084654
The above example is May 30, 2005 @ 8:46:54 am.
Time should be hour:minute:second like 084654. The hour I believe is 24h time.
mysql TIMESTAMP (not a unix timestamp!) are these two concatenated together.
20050530084654
The above example is May 30, 2005 @ 8:46:54 am.
- Thread starter
- #4
clarkmurray
IS-IT--Management
Thanks, but I finally figured out what I was looking at was a Unix timestamp.
so use the FROM_UNIXTIME function, and nest it inside the DATE_FORMAT function
rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)
rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)
- Status