Jump to content

script MySQL Time Format Changer


KarTooN

Recommended Posts

Tento script mění MySQL datum z tvaru RRRR-MM-DD HH:MM:SS nebo RRRR-MM-DD na jiný formát..

 

stock ChangeDatumForm(datum[],frm=0)
{
new str[45],rok[5],mesic[3],den[3];
new nazvy_mesicu[12][9]={
"Leden",
"Unor",
"Brezen",
"Duben",
"Kveten",
"Cerven",
"Cervenec",
"Srpen",
"Zari",
"Rijen",
"Listioad",
"Prosinec"};
if(strlen(datum) == 10)
{
strmid(den,datum,8,11,3);
strmid(mesic,datum,5,7,3);
strmid(rok,datum,0,4,5);
switch(frm)
{
case 1: format(str,sizeof(str),"%d %s %s",den,nazvy_mesicu[strval(mesic)],rok);
default:
{
if(strval(rok) == 9999)
 str="Permanent";
else
 format(str,sizeof(str),"%02d/%02d/%s",den,mesic,rok);
}
}
}
else if(strlen(datum) == 19)
{
 new hodina[3],minuta[3],vterina[3];
strmid(vterina,datum,strlen(datum)-2,strlen(datum));
strmid(minuta,datum,strlen(datum)-5,strlen(datum)-3);
strmid(hodina,datum,strlen(datum)-8,strlen(datum)-6);
strmid(den,datum,strlen(datum)-11,strlen(datum)-9);
strmid(mesic,datum,strlen(datum)-14,strlen(datum)-12);
strmid(rok,datum,strlen(datum)-19,strlen(datum)-15);
switch(frm)
{
 case 1:
format(str,sizeof(str),"%d %s %s %02d:%02d",strval(den),nazvy_mesicu[strval(mesic)],rok,strval(hodina),strval(minuta));
case 2:
{
 if(strval(rok) == 9999)
 str="Permanent";
else
 format(str,sizeof(str),"%02d/%02d/%s",strval(den),strval(mesic),rok);
}
case 3:
 format(str,sizeof(str),"%02d/%02d/%s %02d:%02d",strval(den),strval(mesic),rok,strval(hodina),strval(minuta));
default:
{
if(strval(rok) == 9999)
 str="Permanent";
else
 format(str,sizeof(str),"%02d/%02d/%s %02d:%02d:%02d",strval(den),strval(mesic),rok,strval(hodina),strval(minuta),strval(vterina));
}
}
}
else str="Neplatne datum";
return str;
}

Můžete si výsledný formát upravit dle vlastních potřeb. Snad to někomu bude užitečné.

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...