KarTooN 1 Odesláno: 1. Duben, 2013 Share Odesláno: 1. Duben, 2013 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 More sharing options...
Lerry 15 Odesláno: 14. Duben, 2013 Share Odesláno: 14. Duben, 2013 pěkné Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now