Dsy Network www | forum | my | didattica | howto | wiki | el goog | stats | blog | dona | rappresentanti
Homepage
 Register   Calendar   Members  Faq   Search  Logout 
.dsy:it. : Powered by vBulletin version 2.3.1 .dsy:it. > Didattica > Corsi A - F > Basi di dati ~ informatica triennale > Query
  Last Thread   Next Thread
Author
Thread    Expand all | Contract all    Post New Thread    Post A Reply
Collapse
ripp
.novellino.

User info:
Registered: Jun 2015
Posts: 7 (0.00 al dì)
Location:
Corso:
Anno:
Time Online: 0:52:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
Query

Non ho capito bene questa query
1)una funzione che converte una data dal formato americano
anno-mese-giorno al formato italiano giorno/mese/anno

Grazie in anticipo.

22-06-2015 16:31
Click Here to See the Profile for ripp Click here to Send ripp a Private Message Find more posts by ripp Add ripp to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Cronovirus
dsy core staff

User info:
Registered: Jun 2012
Posts: 471 (0.10 al dì)
Location:
Corso: Magistrale in Informatica
Anno: 2
Time Online: 4 Days, 2:45:03: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Ciao!
Perdonami non ho capito bene cosa chiedi.. Cosa devi fare?

22-06-2015 18:58
Click Here to See the Profile for Cronovirus Click here to Send Cronovirus a Private Message Find more posts by Cronovirus Add Cronovirus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
ripp
.novellino.

User info:
Registered: Jun 2015
Posts: 7 (0.00 al dì)
Location:
Corso:
Anno:
Time Online: 0:52:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

per l'esame praticamente il prof in un esercitazione ha chiesto una query come questa devo trasformare una data dal formato americano a italiano cioè mysql prende come input il formato '2015/06/22' io devo trasformarlo in '22/06/2015'
solo che non sono riuscito a trovare una soluzione qualche idea?

22-06-2015 19:06
Click Here to See the Profile for ripp Click here to Send ripp a Private Message Find more posts by ripp Add ripp to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Cronovirus
dsy core staff

User info:
Registered: Jun 2012
Posts: 471 (0.10 al dì)
Location:
Corso: Magistrale in Informatica
Anno: 2
Time Online: 4 Days, 2:45:03: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

http://www.w3schools.com/sql/func_date_format.asp
Questa è molto semplice

22-06-2015 19:30
Click Here to See the Profile for Cronovirus Click here to Send Cronovirus a Private Message Find more posts by Cronovirus Add Cronovirus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
ripp
.novellino.

User info:
Registered: Jun 2015
Posts: 7 (0.00 al dì)
Location:
Corso:
Anno:
Time Online: 0:52:33 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

grazie tante :)

22-06-2015 19:33
Click Here to See the Profile for ripp Click here to Send ripp a Private Message Find more posts by ripp Add ripp to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
All times are GMT. The time now is 17:05.    Post New Thread    Post A Reply
  Last Thread   Next Thread
Show Printable Version | Email this Page | Subscribe to this Thread | Add to Bookmarks

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Powered by: vBulletin v2.3.1 - Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Mantained by dsy crew (email) | Collabora con noi | Segnalaci un bug | Archive | Regolamento | Licenze | Thanks | Syndacate
Pagina generata in 0.032 seconds (74.97% PHP - 25.03% MySQL) con 27 query.