On Friday 06 May 2005 11:17, William Stokes wrote: > OK. I found that out from MySQL manual. I just don't know how to insert the > date formatting function to the query: > > I quessI need to put STR_TO_DATE() in to the following SQL query:
What about DATE_FORMAT()? > > SELECT event_id,name,date,time,place,type,info FROM test_table > WHERE (group = '$group') AND (type = 'Game' OR type = 'training') > ORDER BY date ASC > > I dont know how? > > Thanks a lot > -Will -- Cyberly yours, Petar Nedyalkov Devoted Orbitel Fan :-) PGP ID: 7AE45436 PGP Public Key: http://bu.orbitel.bg/pgp/bu.asc PGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436
pgpogR2tuhWB3.pgp
Description: PGP signature
