Originally Posted by Dokins
Thanks, but they both don't look like what I am asking for, I'm looking for this (Except a working one):
Or failing that a MYSQL query that does it, i'm not sure how to create the function myself, mysql is not a huge strength, yet.
pawn Код:
stock date( timestamp, _form=0 )
{
/*
~ convert a Timestamp to a Date.
~ 10.07.2009
date( 1247182451 ) will print >> 09.07.2009-23:34:11
date( 1247182451, 1) will print >> 09/07/2009, 23:34:11
date( 1247182451, 2) will print >> July 09, 2009, 23:34:11
date( 1247182451, 3) will print >> 9 Jul 2009, 23:34
*/
new year=1970, day=0, month=0, hour=0, mins=0, sec=0;
new days_of_month[12] = { 31,28,31,30,31,30,31,31,30,31,30,31 };
new names_of_month[12][10] = {"January","February","March","April","May","June","July","August","September","October","November","December"};
new returnstring[32];
while(timestamp>31622400){
timestamp -= 31536000;
if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) ) timestamp -= 86400;
year++;
}
if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) )
days_of_month[1] = 29;
else
days_of_month[1] = 28;
while(timestamp>86400){
timestamp -= 86400, day++;
if(day==days_of_month[month]) day=0, month++;
}
while(timestamp>60){
timestamp -= 60, mins++;
if( mins == 60) mins=0, hour++;
}
sec=timestamp;
switch( _form ){
case 1: format(returnstring, 31, "%02d/%02d/%d %02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
case 2: format(returnstring, 31, "%s %02d, %d, %02d:%02d:%02d", names_of_month[month],day+1,year, hour, mins, sec);
case 3: format(returnstring, 31, "%d %c%c%c %d, %02d:%02d", day+1,names_of_month[month][0],names_of_month[month][1],names_of_month[month][2], year,hour,mins);
default: format(returnstring, 31, "%02d.%02d.%d-%02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
}
return returnstring;
}
|
