[admin]

I have an SQL table in an old application that stored the date and time as an integer - int(11). I want to use it in a new ap that uses timedate. How do I convert the data from int to timedate?

[Advertisements]

hi admin, and welcome to G2G!

As for your problem, why not just define the date and time as "datetime" in the first place instead of "int"?

-stettybet0

[stettybet0]

hi admin, and welcome to G2G!

As for your problem, why not just define the date and time as "datetime" in the first place instead of "int"?

-stettybet0

[admin]

I have 1,000+ rows sorted using a date field. If I change them all to a default they won't be in any kind of order. I'd also prefer to keep the date field correct.

[Michael]

I am presuming the integer is a time stamp, is which case you can do

$date = date("Y-m-d",$timestamp);

That will produce something like 1989-12-23 depending on the $timestamp

EDIT: http://au3.php.net/m...nction.date.php

Edited by Michael, 20 April 2007 - 12:37 AM.

[admin]

I want to change the actual data in the table, not parse it with PHP. Looks like FROM_UNIXTIME will work:
http://dev.mysql.com...n_from-unixtime

[Michael]

If your only dealing with about 1000 rows it would be easy to get the date, change it, then update it. But useing pure SQL would be easy enough too.


I personally doing the exact opposite, and changing all to a time stamp (unix time) because it is more flexible, I can easily change it for time zone differences or print it in a number of different formats.