|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Query with TIMESTAMP, PHP+IBASE
i'm having problems with this.
------------------ ibase_timefmt("%m/%d/%Y %H:%M:%S", IBASE_TIMESTAMP); //both, with string and mktime don't work! $FromDate = "24/10/2003 17:50:40"; //$FromDate = mktime (17,50,40,10,24,2003); $ToDate = "27/10/2003 17:50:40"; //$ToDate = mktime (17,50,40,10,30,2003); $stmthistory = "select * from machine_history where (hdate >= ('$FromDate')) and (hdate <= ('$ToDate'));"; $queryhistory = ibase_prepare($stmthistory); $rshistory=ibase_execute($queryhistory,$stmthistory); $rowhistory = ibase_fetch_row($rshistory); ----------------------- this code return the error: Warning: ibase_fetch_row(): conversion error from string "27/10/2003 17:50:40" in .......... how do i make this query? thanks. Interactive Minds URL |
|
#2
|
|||
|
|||
|
Try '2003-10-27 17:50:40' with simple quotes
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Query with TIMESTAMP, PHP+IBASE |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|