Thread: Zend_Db_Adapter and UNIX_TIMESTAMP() function : how to ?
View Single Post
  #2 (permalink)  
Old 04-19-2008, 07:01 PM
Piro's Avatar
Piro Piro is offline
Junior Member
  
Join Date: Apr 2008
Location: Holland
Posts: 8
Default
You have an error in your query near *. I'm assuming you want to get the timestamp of a field and the rest of all the fields so you need to put a comma before the * sign.

Code:
SELECT UNIX_TIMESTAMP(start_date) AS date_unix, * FROM tournament
Reply With Quote