Convert 'MMDDYYYY' in database

I try to find out how "1151958691" = to October 2, 2005 what kind conversion do they use?


Thanks

 

I would convert it using php/asp before you enter it into the database.

http://www.php.net/date

 

I prefer to keep dates as ints or longs in the database. It makes comparisons easier and for me is more maintainable. The conversion depends on the language you are using.

 

hi there,

if this is a unix system, then dates are stored as "seconds since 01.01.1970" afaik. ont know what you want to do with the date, but its a good idea to use the mysql function instead of asp/php (its faster).

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

i try to find out what kind conversion is that...also they are using php language

any ideals?

 

it's a unix timestamp isnt it?

 

not sure what it is, but this:

$test=1151958691;
echo date("r", $test);

Code (markup):

returns "Mon, 03 Jul 2006 22:31:31 +0200". is this close enought to October 2, 2005 for your needs?
if you dont have a typo in your number then you must provide the function who created this number to build a invert function.

 

Maybe time stamp +- some value? Explore other values

FROM_UNIXTIME(unix_timestamp,format) 
Returns a string representation of the Unix timestamp, formatted according to the format string. format may contain the same specifiers as those listed in the entry for the DATE_FORMAT() function: 
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),
                            '%Y %D %M %h:%i:%s %x');
        -> '1997 23rd December 03:43:30 1997'

Code (markup):