
April 4th, 2004, 01:59 AM
|
|
|
|
Join Date: Apr 2007
Posts: 101
Time spent in forums: < 1 sec
Reputation Power: 2
|
|
|
RE: mysql timestamp
OK,duh DATE_FORMAT is mysql not php, so I have to do something like this
php Code:
Original
- php Code |
|
|
|
$query_registrations = sprintf("SELECT events_workshopReg.record_id, events_workshopReg.ws_id, DATE_FORMAT('events_workshopReg.dateSrv', '%%m %%d %%y'), events_profile.record_id, events_profile.first, events_profile.last, ...etc
but this part DATE_FORMAT('events_workshopReg.dateSrv', '%%m %%d %%y'), isn't quite right. What would the syntax be?
--rayne
|